You're welcome.

Hopefully, one of our suggestions worked!


--
Biff
Microsoft Excel MVP


"AJ Patel" wrote in message
...
Thanks to you both for your help

"AJ Patel" wrote:

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