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?