AVG within parameters

[Brown]

I have a question i know you guys can answer.
I have a column of random numbers (test scores) and I need to find the percentage of 90-99, 80-89, 70-79, 0-69

is there a way to have excel take the list of numbers, sort them (fingers crossed), and then find the percentage of A's (i.e. 90-99) from the given total of scores entered? The number of tests will be different for each teacher.

I hope this makes sense. the more i can do before sending to people who are not good with excel will help greatly.
Thanks
Brown

 

[Peter_SSs]

I have a column of random numbers (test scores) and I need to find the percentage of 90-99, 80-89, 70-79, 0-69

See if this does what you want.

With the list of scores in column A, select 4 vertical cells (I have used C2:C5), enter the formula shown in the formula bar, without the surrounding {}, and confirm with Ctrl+Shift+Enter, not just Enter. If confirmed correctly Excel will insert the surrounding {} and fill all 4 cells. Note that this is not one cell entered then copied down.

I have manually entered the grades in column D.

Excel Workbook
	A	B	C	D
1	Score		%	Grade
2	26		10%	D
3	95		20%	C
4	92		40%	B
5	75		30%	A
6	84
7	81
8	84
9	88
10	99
11	72
Grade %

 

[Brown]

i am not sure why my replies are not showing.

 

[Brown]

this is what i have built.
i want to be able to give it to other teachers and have them type in their scores and return the data i need, without having to do all of it manually





[IMG


G][/IMG]

 

[Peter_SSs]

this is what i have built.
i want to be able to give it to other teachers and have them type in their scores and return the data i need, without having to do all of it manually

Can't tell a real lot from just looking at a picture, but it seems like my suggestion should do what you want. Have you tried it?

 

[Aladin Akyurek]

Can't tell a real lot from just looking at a picture, but it seems like my suggestion should do what you want. Have you tried it?

Myabe easier to run...

In C2 just enter and copy down:

=IF($D2="","",INDEX(FREQUENCY($A$2:$A$11,{69,79,89,100}),ROWS($C$2:C2))/COUNT($A$2:$A$11))