SUMIFS with 3 conditions

Noemi K
Noemi K ✭✭
edited 12/09/19 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!