Using a Blank Cell as Part of a SUMIFS Criteria

I came across this when I was having difficulty reconciling a sum total against a breakout of the component pieces and realized that my data had blanks associated with numerical data, so in order to double check the reconciliation, I needed a “SumIFS” with blank cells as my criteria.

It took longer than I expected to find a solution, so I wanted to post it here.

In the example below, I want to derive a Sales figure based on the Blank Cells in either Column A or Column A AND Column B.

SUMIFS with Blank Cells

In this way, you can use the Excel SumIFS function to consider the blank cells as a criteria.