View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default 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