Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using COUNTIF to find how many times 2004 occurs
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!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i find a true value between two different times e.g. 4:15 | Excel Discussion (Misc queries) | |||
I need to find out how to multiply gross hours times amount of pay. | New Users to Excel | |||
Using COUNTIF for a word that is joined by another word in same ce | Excel Discussion (Misc queries) | |||
How do I find the amount of hours between times? | Excel Discussion (Misc queries) | |||
How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) |