I actually need it to look at another column before giving me a total for
example using your data if all the animals are written in column A, I need a
running total as long as the values in column B are unique
A B Result
mouse 1 mouse = 2
fish 2 fish = 4
dog 3 dog = 3
mouse 4 cat = 2
dog 5
fish 6
fish 6
cat 7
fish 8
dog 9
fish 10
cat 11

As you see in column A fish shows 5 times however in column B there are two
instances that 6 shows, so I want to disregard that 2nd fish in my running
total and any further instances of fish that has 6 in column B
"Gary''s Student" wrote:

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.