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