Counting Specific Text

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I would like to be able to count the number of times a
particular text entry is listed within a column. For
example if there is a list and Apples are in the list 4
times, I would like a formula that would count the number
of times apples appeared in colunn A and place that number
in column B. Thanks for the help.

Todd
 
Todd

If you want to summarise more than one type, you may be better off using a
pivot table (from Data/Pivot Table). If it's just a one-off use:
=COUNTIF(A1:A100,"Apples")

Andy.
 
Hi Todd,
=COUNTIF(A1:A101="Apples") 0r =COUNTIF(A1:A101=c1) where C1 has the value
'apples'.
Note the Excel is not case sensitive.
Bernard
 
Select the cell in column B and enter the below formula

=countif(________,"Apples")

In the missing space you select the cells you want apples
to be counted in. so maybe it would be:

=countif(A4:A14,"APPLES")

Hope that is ok?

Regards
 
Back
Top