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

=COUNTIF(A:A,"apple")


Gord Dibben MS Excel MVP

On Tue, 25 Jul 2006 19:09:09 -0400, 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

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

=COUNTIF(A:A,"apple")

Vaya con Dios,
Chuck, CABGx3



"krs1040" wrote in
message ...

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