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

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

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

Try this:

=SUMPRODUCT((A1:A7="bob")*(B1:B70))

HTH
Elkar


"Robert" wrote:

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