BeginnerTotals and maths
Syntax
=AVERAGE(number1, [number2], ...)| Argument | What it means |
|---|---|
number1 | The numbers, cells or range to average. |
number2, ... | Optional. More numbers or ranges. |
Examples with results
Every result below is calculated by the practice engine on the sample data shown, not typed in by hand.
Class scores (fictional)
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Student | Maths | Science | English |
| 2 | Layla | 78 | 85 | 91 |
| 3 | Omar | 62 | 70 | 58 |
| 4 | Priya | 95 | 88 | 92 |
| 5 | Quinn | 45 | 52 | 61 |
| 6 | Rosa | 88 | 79 | 84 |
=AVERAGE(B2:B6)Average Maths score
=ROUND(AVERAGE(B2:D2),1)Layla’s average across three subjects, rounded to one decimal
Try it yourself
Change the formula or switch to other sample data.
Press Calculate to see the result.
The practice box runs in your browser with BDK’s own calculator, which covers about 60 common functions. Cell references work as in Excel (B2, B2:B9). Your formulas are not saved or sent anywhere. For anything unusual, check the result in Excel itself.
How people use AVERAGE at work
- Education
Class average for Science.
Data: Class scores (fictional)=AVERAGE(C2:C6) - HR
Average salary across the team.
Data: Team list (fictional)=ROUND(AVERAGE(C2:C8),2)
Common mistakes and tips
- Empty cells and text are skipped, but a zero is counted. A blank score is not the same as 0.
- If no cell contains a number the result is a #DIV/0! error. Wrap it in IFERROR if the range can be empty.
Works in
All versions of Excel, and Google Sheets.
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.