Hi community-
I'm looking for a formula to sum up working hours for various employees , grouped by Optician ID, if they had an active contract within a certain month.
I've played around with SUMIFS, but I get an error message, that it's not a formula.
=SUMIFS(G:G;B:B;J3;E:E;<=DATE(2021,3,1);AND(F:F>DATE(2021,3,1);F:F;=""))
Any pointers are most apreciated!
Be well!
Sasa
I'm looking for a formula to sum up working hours for various employees , grouped by Optician ID, if they had an active contract within a certain month.
I've played around with SUMIFS, but I get an error message, that it's not a formula.
=SUMIFS(G:G;B:B;J3;E:E;<=DATE(2021,3,1);AND(F:F>DATE(2021,3,1);F:F;=""))
Any pointers are most apreciated!
Be well!
Sasa