MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sumif (criteria blank)

Posted by George on June 06, 2001 6:56 AM

Range - open/closed log (open logs have no numerical
tag closed logs have numerical tags to
indicate they have been resolved)
Criteria - I would like it to be <> to blank so I could
tally all closed issues
Sum_range - $ value of closed issues

Posted by Aladin Akyurek on June 06, 2001 7:07 AM

In C2 enter: =SUMIF(A2:A7,"<>"&"",B2:B7)

where I assume numerical tags to be in A2:A7 and dollar values in B2:B7.