Formulas and Functions

Table Of Contents

Example

Assume the following table contains the test scores of 30 students who recently took an exam you

administered. Assume further that that the minimum passing grade is 65 and that the lowest score

for other grades are as given. In order to facilitate building the formulas, an “F” is represented by 1

and an “A” by 5.

=INDEX(FREQUENCY($A$1:$F$5, $B$8:$E$8), B9) returns 5, the number of students who received an

“F” (score of 65 or less). This formula can be entered in cell B10 and then extended across to cell F10.

The resulting values returned for grades of “D” to “A” are 3, 8, 8, and 6, respectively.