SUMIFS Formula Returning 0

Darla Brown

Hi,

I am doing a simple SUMIFS formula that is returning zero instead of the actual sum. Just for reference, the numbers in January's column are manually entered. The zero in February is where I am testing my formula. I have rearranged this formula so many times and it still returns zero instead of the $585.

=SUMIFS([Grand Total-SUM-Charge Amount]:[Grand Total-SUM-Charge Amount], Month:Month, 1, Rows:Rows, "Commercial Supplier")

Heather Duff

Hi Darla,

With the criteria you have listed in your SUMIFS formula, it's looking for rows that have the month listed as 1 AND the Rows listed as Commercial Supplier. Because there is no month entered in the parent row (where Commercial Supplier is listed), it's not going to find anything to sum. Does that make sense?

You would need to enter Commercial Supplier in the Rows column, in the 2nd row shown, in order for the formula to work as you have it listed.

Hope this helps!

Best,

Heather