Average of Certain Range of Scores between 70-100

Originally Posted by Moo the Dog

If your scores are in column B

=AVERAGEIF(B1:B9,">=70")

- Moo

I MADE A MISTAKE! I mean I need an average of the students that scored 70% or above out of all of the students.

For example: If I had 10 kids, and 4 made a 70% or above, then the pass rate is: 40%

I apologize!

DAMON JASSO
Ortizmiddleschool.org