# SUM, AVERAGE, MIN, MAX & COUNT (Excel lesson 2 of 45)

> Five functions answer most questions about a list of numbers.

Source: https://spreadsheetpractice.com/learn/sum-average-min-max-count · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Foundations"
- **Time:** about 7 minutes, 3 graded exercises
- **Functions:** `SUM`, `AVERAGE`, `MIN`, `MAX`, `COUNT`, `COUNTA`
- **Access:** free
- **Key formula:** `=SUM(B2:B8)`: Add a range

## How it works

A function is a named calculation that takes arguments in parentheses. A range like `B2:B8` means every cell from B2 to B8, so `=SUM(B2:B8)` adds the whole week.

These functions skip text and empty cells. That is usually what you want, but it changes the math: `AVERAGE` divides by how many numbers it found, not by the number of rows. `COUNT` counts numbers only; `COUNTA` counts anything that isn't empty.

## Syntax

| Formula | What it does |
|---|---|
| `=SUM(B2:B8)` | Add a range |
| `=AVERAGE(B2:B8)` | Mean of the numbers |
| `=MAX(B2:B8)` | Largest value |
| `=MIN(B2:B8)` | Smallest value |
| `=COUNT(B2:B8)` | How many numbers |
| `=COUNTA(A2:A8)` | How many non-empty cells |

## Watch out for

- AVERAGE ignores the "Closed" day, so it averages 6 days, not 7.
- In desktop Excel, Alt+= (Windows) or ⌘+Shift+T (Mac) inserts SUM for you.

## The exercises

Solve them in the live grid at [SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count). Each answer is graded, then re-checked on changed data so typed-in numbers don't pass.

1. **Weekly total.** In E2, add up the week's sales in B2:B8.
2. **Average, best and worst.** Fill in E3 (average daily sales), E4 (best day) and E5 (worst day), each from B2:B8.
3. **Counting cells.** In E6, count the days with a sales number. In E7, count how many days are listed in column A.

Previous: [Your first formula](https://spreadsheetpractice.com/learn/first-formula) · Next: [Relative vs absolute references](https://spreadsheetpractice.com/learn/relative-absolute-references)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
