Thank you for all those that helped me with the count function for running
total. Now I want to take that a little further, using the following
worksheet
A B C D
1 Bat Defective 1
2 Bat Defective 1
3 Ball Defective 2
4 Bat Defective 3
5 Bat Good 4
n Glove Defective 5

I want a running total of bat, ball, glove, using those values as a search
string, that are defective from column B, and the value in C does not match.
So basically I need to first look at colum B grab all that are defective,
then look at column A grab 1st "Bat" using "bat" as the search string, then
get a running total of all bats that are defective, that the value in column
c does not match.
For our example my results should be
bat = 2
ball = 1
glove = 1