Counting occurances in one column if another col. meets a certain

[Guest]

Given the following:

bob 1000
tom 0
bill 200
steve 50
bob 0
tom 15
bob 25

How would I create a formula to count the quantity of numers greater than
"0" if the first column is (for example) Bob? The answer for bob should be
2, Tom 1, etc. Thanks! Robert

 

[Guest]

Try this:

=SUMPRODUCT((A1:A7="bob")*(B1:B7>0))

HTH
Elkar