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

Options
edited 06/12/23

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?

• ✭✭✭✭✭✭
Options

=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.

• ✭✭✭✭✭✭
Options

=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.

• ✭✭✭✭✭✭
Options

I am confused about whether you are trying to do this individually per row, or if you want results for the entire sheet. This will give you an individual row:

=IF([Open/Closed]@row = "Closed", [Original Amount]@row + [Late fees]@row, "")

• Options

Amazing, thank you so much!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!