=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