How to use the SUMIFS function to exclude the Null String (="")

Question

I'm trying to exclude a value from a summation if a corresponding value in another column (B6) is a Null String (="").  The following formula works fine if the corresponding value is BLANK:

It does not work if the corresponding value (in B6) is the Null String (=""):

Can anyone tell me how to change the criteria in my SUMIFS formula to correctly handle this case?

Answer 1

Hi,

Not clear to me, don't see the issue, can you share the workbook and tell us what is wrong?

Answer 2

Hi Mark!

Try this formula:

=MIN(SUMIFS(A4:A8,B4:B8,"<>"&{"";"*"}))

If possible, you can try this too:

=SUMIFS(A4:A8,B4:B8,">=0")

Markmzz

Answer 3

Hi,

Try this

=SUMPRODUCT((ISNUMBER(B4:B8))*(A4:A8))

Hope this helps.

Answer 4

You may try,

=SUMIFS(B4:B8,C4:C8,"<>*")