Receive #VALUE! when I mix text with dates using SUMPRODUCT

R

Rick

Hello,

I'm trying to get a count of the number of times a specific year (2007 in
this case) is displayed under one column using this formula:

=SUMPRODUCT(--(YEAR(C6:C52)=2007))

Everything works fine until anything but a date is entered within column C,
which it then gives me the #VALUE! error. Is there any way that SUMPRODUCT
can bypass or ignore those cells which include text?

Thanks,
Rick
 
Z

Zack Barresse

Hi Rick,

Try something like this ...

=SUMPRODUCT(--(YEAR(C6:C52)=2007),--ISNUMBER(C6:C52))

HTH
 
R

Rick

Nope, still the same thing. I tried switching the ISNUMBER function to the
first array as well, and still no luck.
 
Top