Sumifs
Hello,
I was wondering if anyone could help me with a sum ifs function. A screenshot of the sheet is included. Basically I want a formula that says if the course name match and the date match, total the costs.
So in the example if the course date is 9/16/2024 and the course name is 300, add the three rows of cost.
I can get it to sum for each individually =sumif(Date:Date, [Date]@row) and =sumif(Course Name:Course Name, [Course Name]@row). But when I try to combine it does not work. I am not sure if it should be an (AND in there or something. Thanks!
Best Answer
-
Hi @Whalstead1,
You're correct that you want to use the SUMIFS function for this problem. The syntax for SUMIFS is a little bit different than the syntax for SUMIF.
This formula should work for you:
=SUMIFS(Cost:Cost, [Course Name]:[Course Name], [Course Name]@row, Date:Date, [Date]@row)
This will search the rows, and sum the costs if the course names match and the dates match.
Let me know if you have any questions about the formula!
SSFeatures - The browser extension that adds more features into SmartSheet.
- Automatic sorting, sorting with filters, saving sort settings
- Spell checking
- Report PDF generator that supports grouped and summarized reports
Answers
-
Hi @Whalstead1,
You're correct that you want to use the SUMIFS function for this problem. The syntax for SUMIFS is a little bit different than the syntax for SUMIF.
This formula should work for you:
=SUMIFS(Cost:Cost, [Course Name]:[Course Name], [Course Name]@row, Date:Date, [Date]@row)
This will search the rows, and sum the costs if the course names match and the dates match.
Let me know if you have any questions about the formula!
SSFeatures - The browser extension that adds more features into SmartSheet.
- Automatic sorting, sorting with filters, saving sort settings
- Spell checking
- Report PDF generator that supports grouped and summarized reports
-
Thank you so much! That worked!
-
You're welcome, glad it worked!
SSFeatures - The browser extension that adds more features into SmartSheet.
- Automatic sorting, sorting with filters, saving sort settings
- Spell checking
- Report PDF generator that supports grouped and summarized reports
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!