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

Tanishia W

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?

Hollie Green

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

Hollie Green

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

Carson Penticuff

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, "")

Tanishia W

Amazing, thank you so much!!