Try...

=SUMPRODUCT(--ISNUMBER(1/(YEAR(C6:C52)=2007)))

Hope this helps!

In article ,
Rick wrote:

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