Nope not working for Jan

I have got the following formula working for every month except Jan, I dont
whats going on

=SUMPRODUCT(--(MONTH('Tracker 2010'!$Q$6:$Q$2643)=2),--('Tracker
2010'!$D$6:$D$2643="Whyte"))

I'm banging my head against a wall here

"Luke M" wrote:

=SUMPRODUCT(--(TEXT('Tracker 2010'!T6:T2643,"mm")="01"))

--
Best Regards,

Luke M
"DaveC" wrote in message
...
Hi Folks,

I am using the following formula to try to count how many cells contain a
date within January but its not working for me

=SUMPRODUCT((MONTH('Tracker 2010'!T6:T2643)=1)*('Tracker 2010'!T6:T2643<"
"
))

Date format is 13/01/2010 in T6, 16/01/2010 in T7 and so on

Any help you could give is appreciated

Dave







.