Sumifs on a null or blank

[Tarver]

I'm using SUMIFS to calculate a Balance, but some of my criteria are intentionally blank in some entries.

As in the screenshot, I don't want to include the "Invoice" document type (and others) but I do need to include the "Refund" type and the null/blank type (and others.) I've tried excluding all criteria except the ones I need, I've tried including all of the criteria I need, and I'm still unable to get Excel to include the Balance amount from my rows with blank cells.

How can I include these blanks and still get the correct sums?

Thanks!

 

[jasonb75]

As you want to include blanks (which may make it difficult with multiple criteria for that column), I would say that the best way would be

=SUM(range to sum)-SUM(SUMIFS(range to sum, criteria range, array of items to exclude))

 

[Tarver]

As it turns out, my problem here was NOT that the field was blank. There was an invisible character in there, and that was gumming up the works. When the blank wouldn't be picked up my SUMIFS, I checked the LEN of the blank cell and was surprised to find it was 1. Then I did a whole bunch of IF statements to find if the VALUE of the cell was CHAR(1), CHAR(2), etc. until I got a hit on CHAR(32).