Hi everyone

I am trying to count that if the name in T21 is anywhere in column D and the
corresponding cell in column A is between the 01/01/2010 and the 31/01/2010

I have written the following but its not working - where am I falling down
please?

=SUMPRODUCT(($D$2:$D$618=T21)*($A$2:$A$618=01/01/2010,<31/01/2010))

Thanks as always

Lise