SUMIFS() formula showing unexpected results.

zealvert

Hi

I just tested and found out that if I am keeping the Status field blank, then the SUMIFS() function is not processing that row. I have pasted below -- the Summary cell formula, and the results coming in both the scenarios:

Sheet summary formula

=SUMIFS(Amount:Amount, [Due date]:[Due date], <=(TODAY() + 7), Status:Status, <>"Paid")

Scenario 1 results (Status field was blank here):

Scenario 2 results (Status field was not blank here):

Any clues please?

Thanks

KPH

Hi

You can add an OR to your second criterion to say include rows where Status doesn't equal "Paid" or is blank

=SUMIFS(Amount:Amount, [Due Date]:[Due Date], <=(TODAY() + 7), Status:Status, OR(@cell = "", @cell <> "Paid"))

zealvert

Thanks a lot, @KPH ! It worked!

KPH

Hi

You can add an OR to your second criterion to say include rows where Status doesn't equal "Paid" or is blank

=SUMIFS(Amount:Amount, [Due Date]:[Due Date], <=(TODAY() + 7), Status:Status, OR(@cell = "", @cell <> "Paid"))

zealvert

Thanks a lot, @KPH ! It worked!

KPH

Happy I could help!