Course / Spreadsheet Basics

AVERAGE, MIN and MAX

Summarise a list with its typical, smallest and largest values. Beginner · 3 min · AVERAGE, MIN, MAX

These functions work just like SUM: give them a range and they return a single number.

• AVERAGE gives the mean
• MAX gives the largest value
• MIN gives the smallest value

Steps

1. In E2, calculate the average daily steps.

2. In E3, find the highest step count.

3. In E4, find the lowest step count.

4. In E5, subtract the quietest day from the best day. Use the cells you just filled in.

Remember

• AVERAGE, MIN and MAX each take a range and return one number.
• Formulas can build on other formulas' results.
• Select a range and glance at the status bar under the grid: it shows the sum, average and count instantly.

Previous: SUM and AutoSum · Next: Counting cells