Using COUNTIF to find how many times 2004 occurs
What's in F2:F463?
I put 2004 in a few cells and your first formula worked fine.
If you really have dates, then you could use:
=sumproduct(--(year(f2:f463)=2004))
to get the count.
Millie wrote:
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!!
--
Dave Peterson
|