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!

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")/10I am assuming that you will not have any scores

between84% and 85% orbetween94% 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.

Thank you!!! It worked perfectly.

The % will be in whole numbers, so this works great!

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History