SUMIFS with 3 conditions
Hi
I am trying to calculate the total number of worked hours within a week/ month which match 2 more criteria. At the moment I have fr the monthly formula 9 September):
=SUMIFS({003 Project Timesheets Range 2} , {003 Project Timesheets Range 1,"Noemi K", {003 Project Timesheets Range 3} , "Testing" and ({003 Project Timesheets Range 5},MONTH(@cell) = 9 }))
I would like to know how many hours has Noemi K worked on "testing" project in September. I have several people submitting data with different projects in the same sheet and i need to create some sort of time sheet/ person
I am stuck and can't seem to figure out how to add 3 criteria instead of 2.
Can anyone help me please? Is this even possible?
Comments
-
Hi Noemi,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
You would add the 3rd set following the same syntax as the second and first sets.
=SUMIFS(range to sum, criteria range 1, criteria 1, criteria range 2, criteria 2, criteria range 3, criteria 3, criteria range 5, criteria 5, criteria range 6, criteria 6, ...........................................................................)
.
The only limit to how many range/criteria sets I have found thus far is the limit of 4,000 characters per cell. Just continue the pattern of criteria range, criteria and include everything you need.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!