not sure how to ask this

[Brown]

Ok i am trying to collect some data on test scores.

i will have a column of scores entered
i need to find a percentage of grades between certain numbers (70-79, 80-89, 90-100) and the total tests taken

is this making sense?

i am envisioning a column of grades (column A) and then in another column I will have the percentage in a cell (like B1-As, B2-Bs)
so if you can give me the formula to figure out the percentages from the random tests scores i can figure out all the rest.
Thanks
Brown

I am building this spreadsheet for people not familiar with excel so it will calculate things for them if they input the numbers.

[/URL][/IMG]

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1055271-avg-within-parameters.html#post5067155

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).