Thread: Using COUNTIF to find how many times 2004 occurs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Millie
 
Posts: n/a
Default Using COUNTIF to find how many times 2004 occurs
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!!

Reply With QuoteReply With Quote