Thread: [Solved] SumIFS Questions
View Single Post
 
Old 12-10-2012, 03:35 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

There is a subtle difference between these two, but both probably do what you need:
Code:
=SUMIFS(F2:F29, C2:C29,"PSL", D2:D29, "=")
or
=SUMIFS(F2:F29, C2:C29,"PSL", D2:D29, "")
The first formula will only sum when the cells in column D are completely empty. The second formula will only sum when the cells in column D are completely empty or contain a zero length string.
Reply With Quote