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

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History