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
|