Its even simpler than you think:

=COUNTIF(F2:F463,2004)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Millie" wrote in message
...
I'm using a COUNTIF to find how many times the year 2004 occurs
in a column.
I've tried the function several different ways, and always come
up with zero.

=COUNTIF(F2:F463,"=2004")
=COUNTIF(F2:F463,"=*2004")

Help!!