Sumproduct in between dates muliple criteria

[nickmessick1]

Howdy,

I am trying to use a sumproduct to sum the total overtime money for employees. The sum needs to be between two dates and includes three other criteria.

I appreciate any help.

See below

Sum of overtime.xlsx

[Zealotwraith]

why not use a pivot table??

Put date as a filter,

and set row labels as div and employee

Sum of values put sum of OT

[XOR LX]

Hi,

You're going to kick yourself, but after all that good formula work you've gone and got your greater than and less than signs the wrong way round!

Regards

[FDibbins]

Yup, good catch XorXL.

And seeing as you are using 2010, you could also use the sumifS() function, it is a bit easier to use...
=SUMIFS(D:D,A:A,">="&H2,A:A,"<="&I2,B:B,G3,C:C,F3)

[nickmessick1]

HAHA, that worked great, brainfart!. This is kind of like when someone asks help to turn on a TV and I didn't plug it in!!!

Thanks.

[FDibbins]

been there done that lol