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.