=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