Use a Pivot Table. Given a list in a column, it can list each item uniquely
and the number of items the item occurs in the list. For example:

animal
fish
dog
mouse
dog
fish
fish
cat
fish
dog
fish
cat


will produce:

Count of animal
animal Total
cat 2
dog 3
fish 5
mouse 1
Grand Total 11

--
Gary''s Student - gsnu200772


"AJ Patel" wrote:

I am trying to come up with a formula that will look at column, look for a
word or set of words, and give me a running total in another column. For
example, use the following worksheet
A B C D
1 Ball Ball 2
2 Bat Bat 1
3 Ball Glove 1
4 Glove

In cell D1 I want a running total of all instances of Ball from Row A,
similarly in cell d2 I want a running total of all instances of Bat from Row
A, and so on.