Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

SUMIF to sum only if test-value field is non-blank?

Hey Numbers experts, I'm looking for a way to conditionally sum the values in a column. In other words, if the corresponding field in my "test values" column is blank, I do not want to include the value from the same row in my "sum values" column. Is there a way to do this?


It seems that SUMIF is the perfect function, I just can't figure out a way to make it look for only non-blank fields. the test values, except for the blank fields, are all going to be unique values, so there is really nothing else to use as a test other than the presence or absence of data. Help?


Thanks in advance!

iMac, OS X Mavericks (10.9.4)

Posted on Feb 23, 2015 2:14 PM

Reply
Question marked as Best reply

Posted on Feb 23, 2015 2:49 PM

C2=SUMIF(A, "<>"&"", B)

this is shorthand for... select cell C2, then type (or copy and paste from here) the formula:

=SUMIF(A, "<>"&"", B)


User uploaded file


the expression:

"<>"&""


reads:

"is not equal to the empty string"

3 replies

SUMIF to sum only if test-value field is non-blank?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.