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?
Help Article Resources
Check out the Formula Handbook template!