Sum working hours based on valid contract

[Sasa1]

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

 

[Crystalyzer]

Where are the contract dates stored? can you post your data using XL2BB tool? This will make it MUCH easier to try to assist you.

 

[Fluff]

If you put put actual dates in K2:R2 using the 1st of the month then you can put this in K3 dragged down & across

=SUM(FILTER($G$2:$G$100,($B$2:$B$100=$J3)*($E$2:$E$100<=K$2)*(($F$2:$F$100>=EOMONTH(K$2,0))+($F$2:$F$100=""))))