Can I add multiple rows together based on criteria? (Sumif)

Tanishia W
edited 06/12/23 in Formulas and Functions

Hello everyone, I'm looking for help with the Sumif formula or guidance on which one I should be using. What I'm trying to do is add the "Original Amount" and "Late fees" columns together based on them being closed. I have tried =SUMIF([Open/Closed]:[Open/Closed], "Closed", [Original Amount]:[Original Amount]) + [Late fees]:[Late fees]) but that's not working. Any advice?

Best Answer

  • Hollie Green
    Hollie Green ✭✭✭✭✭
    Answer ✓

    =SumIf([Open/Closed]:[Open/Closed],"Closed",[Original Amount]:[Original Amount])+Sumif([Open/Closed]:[Open/Closed],"Closed",[Late fees]:[Late fees])

    The above formula will add together all of original amount that are closed and all of the late fees that are closed then add the two together.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!