Text Counting

[krs1040]

I am looking for a simple function to add up the number of cells filled
with a certain word in a list or column (see below)

Column A

1 Apple
2 Orange
3 Pear
4 Apple

I want a function that will return the number 2 as I count the number
of times “Apple” appears in Column A

 

[Gord Dibben]

=COUNTIF(A:A,"apple")


Gord Dibben MS Excel MVP

 

[Guest]

Try this:

=COUNTIF(A1:A100,"Apple")

or, if you want to also count "Apple Pie" and "Green Apple" as well:

=COUNTIF(A1:A100,"*Apple*")

HTH,
Elkar

 

[CLR]

=COUNTIF(A:A,"apple")

Vaya con Dios,
Chuck, CABGx3