How do I use SUMIFs, with multiple criterion ranges, but for 1 of those ranges, multi criterion?
The Formula that is partially working now is:
=SUMIFS([Estimated Hours]:[Estimated Hours], Status:Status, "Done Feb", Project:Project, "Practice Bootcamps", Owner:Owner, "Melissa Robson")
The thing I am trying to add though is multiple criteria in the Status criterion range. Right now it is only pulling "Done Feb" but I want it to also sum up Estimated Hours in "Prioritized" "In Progress" and "Blocked" as well.
I've been searching but not finding a solution for this particular instance.
Answers
-
@Mrobson To have the formula consider rows with various values in the same range, you can use the OR function within the SUMIFS. The OR function tells the formula to consider a value true if it's any of the included values:
=SUMIFS([Estimated Hours]:[Estimated Hours], Status:Status, OR(@cell = "Done Feb", @cell = "Prioritized", @cell = "In Progress", @cell = "Blocked"), Project:Project, "Practice Bootcamps", Owner:Owner, "Melissa Robson")
Make sure that you remember to close off the OR with an end parentheses so that it is self-contained as the criteria for the Status:Status range.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!