SUMIFS() formula showing unexpected results.

Options
zealvert
zealvert ✭✭✭✭
edited 11/13/23 in Formulas and Functions

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

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!