AVERAGE
Find the middle of a set of numbers
0 of 3 done · Lesson 2 of 18
Understand
The total tells you how much came in. It does not tell you what a normal order looks like. Someone asks what a typical order is worth, and AVERAGE answers that in one step instead of two.
=AVERAGE(what to average)
A worked example
=AVERAGE(E2:E9)
what to average
This returns 10
The sheet you are working with
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Order | Customer | Region | Amount | Units |
| 2 | 1042 | Northwind | Otago | 1250 | 12 |
| 3 | 1043 | Kea Ltd | Waikato | 840 | 5 |
| 4 | 1044 | Halcyon | Otago | 2110 | 20 |
| 5 | 1045 | Brightsmith | Auckland | 560 | 3 |
| 6 | 1046 | Tuatara | Waikato | 1780 | 15 |
| 7 | 1047 | Fernway | Otago | 930 | 8 |
| 8 | 1048 | Pounamu | Nelson | 1420 | 11 |
| 9 | 1049 | Rimu Co | Otago | 670 | 6 |