Text Counting

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

=COUNTIF(A:A,"apple")


Gord Dibben MS Excel MVP

On Tue, 25 Jul 2006 19:09:09 -0400, krs1040
<krs1040.2bixeu_1153869009.4553@excelforum-nospam.com> wrote:

>
>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

=COUNTIF(A:A,"apple")

Vaya con Dios,
Chuck, CABGx3



"krs1040" <krs1040.2bixeu_1153869009.4553@excelforum-nospam.com> wrote in
message news:krs1040.2bixeu_1153869009.4553@excelforum-nospam.com...
>
> 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
>
>
> --
> krs1040
> ------------------------------------------------------------------------
> krs1040's Profile:
http://www.excelforum.com/member.php...o&userid=36783
> View this thread: http://www.excelforum.com/showthread...hreadid=564955
>

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


"krs1040" wrote:

>
> 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
>
>
> --
> krs1040
> ------------------------------------------------------------------------
> krs1040's Profile: http://www.excelforum.com/member.php...o&userid=36783
> View this thread: http://www.excelforum.com/showthread...hreadid=564955
>
>