I did it again and it gave me a a result of over 2,000. This is incorrect, it
should only be returning a value of 16 for Jan. I tried the same formula for
Feb with it changed to 2

=SUMPRODUCT(--(MONTH('Tracker 2010'!T6:T2643)=2))

and it gave me a result of 20 which is correct

I dont understand why its not working for Jan

"BSc Chem Eng Rick" wrote:

Tried it again on my side an it worked fine. Make sure ALL the dates are
actually dates and that some of them are not text.
--
If this helps, please click "Yes"
<<<<<<<<<<<


"DaveC" wrote:

Didn't work, got a #VALUE result

"BSc Chem Eng Rick" wrote:

Try
=SUMPRODUCT(--(MONTH('Tracker 2010'!T6:T2643)=1))
--
If this helps, please click "Yes"
<<<<<<<<<<<


"DaveC" wrote:

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