Using COUNTIF to find how many times 2004 occurs
Hi,
From your formulas, i understand that you want to count those rows in range
F2:F463, where 2004 appears either as a standalone entry or as part of any
other text.. Try this array formula (Ctrl+Shift+Enter) in cell F465
=sum(IF(ISNUMBER(FIND(E465,$F$2:$F$463)),1,0))
Cell E465 contains the text "2004" (w/o the quotes)
Regards,
Ashish Mathur
"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!!
|