Exercises / Foundations · 4 of 12
Average daily visitors
AVERAGE adds up a range and divides by how many numbers it holds. It skips empty cells and text.
AVERAGE(number1, [number2], …)Syntax
The arithmetic mean.
Your taskIn E2, use AVERAGE to find the average number of visitors per day in B2:B8.
I'll check your formula on this sheet and on changed versions of it, so it has to work in general. Stuck? Ask for a hint, one step at a time.
Answer cell
Type in a cell, or double-click it to edit
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Day | Visitors | Measure | Value | ||
| 2 | Mon | 1240 | Average | |||
| 3 | Tue | 1185 | ||||
| 4 | Wed | 1302 | ||||
| 5 | Thu | 1268 | ||||
| 6 | Fri | 1410 | ||||
| 7 | Sat | 1655 | ||||
| 8 | Sun | 1590 | ||||
| 9 | ||||||
| 10 |