Percentage of the Whole

  • Thread starter Thread starter Nate
  • Start date Start date
N

Nate

I have a list of test scores. I want all of the scores
<=28 pulled out of the list. Then I want a percentage
based on the whole. In this case after I pulled out the
scores <=28 I had 21 scores out of 106.

Any ideas of writing a formula to take cae of this with
out doing it by hand. I have tried and tried but canno
seem to come up with one.

Hope my decription makes sense.

Thanks!
 
Sample...
B5:B19 with numbers below:

B5 = 90.00
B6 = 70.00
100.00
100.00
70.00
95.00
75.00
80.00
95.00
100.00
80.00
100.00
85.00
75.00
85.00

B20 = Sum(B5:B19) = 1,300

Cell D4 =(SUMPRODUCT((B5:B19)*(B5:B19>=83)))/B20
 
OK using this same example....how would you write a
formula to tell me the percentage of students below a
score of 83? I don't think those two formulas down there
would work for that would they?
 
Back
Top