Solved find a % of scores from the sheet that is between 0-84%

Microsoft Excel 2010 - complete product...
March 13, 2012 at 11:03:09
Specs: Windows 7
I will try to describe my issue the best I can.

On my worksheet I have a list of names in a column and next to each name in the rows going across is a % score for for each month in a year.

I am trying to get the following

% of scores that range from 0-84%
% of scores that range from 85-94%
% of scores that range from 95-100%

Thank so much in advance!


See More: find a % of scores from the sheet that is between 0-84%

Report •

#1
March 13, 2012 at 11:20:55
✔ Best Answer
Let's say you have 10 scores in A1:A10...

=COUNTIF(A1:A10,"<=.84")/10
=(COUNTIF(A1:A10,">=.85")-COUNTIF(A1:A10,">=.95"))/10
=COUNTIF(A1:A10,">=.95")/10

I am assuming that you will not have any scores between 84% and 85% or between 94% and 95% because you did not ask about those.

Remember that even if Excel displays 84%, the cell might actually contain 84.4% which would be a problem for the formulas that I suggested.

I'll leave it up to you to adjust the formulas to account for that issue.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 13, 2012 at 12:16:33
Thank you!!! It worked perfectly.
The % will be in whole numbers, so this works great!

Report •
Related Solutions


Ask Question