I have a table of say 3 columns. The first column lists the part numbers ,
second column lists the serial number and the third column lists whether the
part test was a success or failure (text).

I want to search in the table of a given part number and return the total
number of times the part number test was a success.

I have tried vlookup, but it stops as soon as it gets a search match. But
the value can appear multiple times in the column and for each matched row I
want to look at the third column and see if the value is "success" and if it
is I want to count it.

Any help is appreciated. Thanks.

NM