View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve C.[_2_] Steve C.[_2_] is offline
external usenet poster
 
Posts: 3
Default If/Count/Sum formula in Excel

A B C
1 20 1 1
2 20 1 1
3 20 1 0
4 40 1 1

Above is an example of the data I have. I want to check column A for a
value of 20, and then first COUNT the values to the right of 20 and second to
SUM the values to the right of 20. Basically want to look at attempts vs.
successes for this system. So in this example, at 20 there are 6 attempts
with 5 sucesses.