What does =YEAR(C4) return (and similarly for the rest of column C)? Are
you sure that you haven't got text, rather than dates, in column C? If you
have, Excel will often translate them to date if they are in the format
expected by your regional settings, but if (for example) your windows
regional settings are looking for mm/dd/yyyy, you'll probably get #VALUE!
responses if you've got dd/mm/yyyy text entries. Similarly if you have a
non-date entry, you'll get #VALUE!
--
David Biddulph

"PSmith" wrote in message
...
I have a column of dates in numeric format of dd/mm/year, and have tried
two
different formulas to count the number that fall in a specific year.

When I use the formula
=SUMPRODUCT(--(YEAR(C4:C24)=2001))
it returns the #VALUE! error

I've tried variations of the COUNTIF formula, to no avail either. Any
suggestions? Thanks