Can I add multiple rows together based on criteria? (Sumif)
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
-
=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.
Answers
-
=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.
-
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, "")
-
Amazing, thank you so much!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!