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!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds essential features into Smartsheet.
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!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds essential features into Smartsheet.
-
Thank you so much! That worked!
-
You're welcome, glad it worked!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds essential features into Smartsheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!