Sheetsdrill

Level 2: Conditional counting and summing Exercise 34 of 92

Average rating without the zeros

A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

A rating of 0 means the store has not been rated yet. Work out the average rating of the stores that have one, leaving the zeros out. Answer in E1.

What this exercise teaches

AVERAGE skips empty cells but counts zeros, which would drag the result down. AVERAGEIF with a criterion leaves the placeholder zeros out of both the sum and the count.

A hint if you get stuck

AVERAGEIF(range, criterion) averages only the cells that pass the test. The test here is ">0".

Functions used: AVERAGEIF

Try it now, free, no account needed

Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Conditional counting and summing