SUMIFS Function | Smartsheet Learning Center
https://help.smartsheet.com/function/sumifsAdds numbers within a range when all given conditions in their respective ranges are met.
Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Trying to tally a column within a set of results
Hello. I've successfully pulled a my results using the formula below. Now I need to include another column to get a tally of the total minutes worked for these specific results. Can I do this in one statement?
=COUNTIFS([Project/Other Type]:[Project/Other Type], "Workshop/Professional Development", Phase:Phase, "Archive", [ID Tier]:[ID Tier], "Primary 1")
Here is the new column
Best Answer
-
Your syntax is off. The SUMIFS function requires the range to be summed first followed by the "filtering" range/criteria sets.
Answers
-
I'm getting the Incorrect Argument Set error.
This is what I'm trying:
=SUMIFS([Project/Other Type]:[Project/Other Type], "Workshop/Professional Development", Phase:Phase, "Archive", [ID Tier]:[ID Tier], "Primary 1", [Total Minutes Worked]:[Total Minutes Worked])
I've tried < and after total minutes worked and still the error. What am I missing?
-
Your syntax is off. The SUMIFS function requires the range to be summed first followed by the "filtering" range/criteria sets.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!