Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 2/7

AVERAGEIF and AVERAGEIFS

Exercise 1 of 3

In F2, work out the average score of class 7A.

About this lesson

AVERAGEIF and AVERAGEIFS average only the rows that match one or more conditions.

In this lesson

  1. In F2, work out the average score of class 7A.
  2. In F2, work out the average of the scores of 50 or more.
  3. In F2, work out the average score of class 7B, counting only scores of 50 or more.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in F2 and press Enter to check.