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
Bookmarks