Hi everyone,

Im using the following

=SUMPRODUCT(--(Data!$C$3:$C$10000=$A8),--((Data!$J$3:$J$10000=I$6)+(Data!$J$3:$J$10000=<I$ 7)),--((Data!$AC$3:$AC$10000="c")+(Data!$AC$3:$AC$10000= "m")))

Where I6 and I7 are two dates including and between which the data should be
included.

Im getting too many returned, so what am I doing wrong?

Any suggestions would be brilliant

Cheers