BeginnerStatistical Functions
Find the average order value with AVERAGE
Calculate the mean value of a set of customer orders.
AVERAGE
3 min10 points
Total a month of sales with SUM
The situation
You have just joined Harbor Supply Co. as an operations assistant. Your manager sends over the daily sales for the first week of October and asks for the weekly total before the 10am stand-up.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Date | Day | Sales | ||
| 2 | Oct 1 | Monday | $4,820 | ||
| 3 | Oct 2 | Tuesday | $5,310 | ||
| 4 | Oct 3 | Wednesday | $4,975 | ||
| 5 | Oct 4 | Thursday | $6,140 | ||
| 6 | Oct 5 | Friday | $7,220 | ||
| 7 | Oct 6 | Saturday | $3,890 | ||
| 8 | Oct 7 | Sunday | $2,410 | ||
| 9 | Week total | ||||
| 10 |
Functions in this exercise
- SUM — Adds up the numbers in a range.
Who this is for
Recommended next
Related exercises
- BeginnerStatistical Functions
Find the average order value with AVERAGE
Calculate the mean value of a set of customer orders.
AVERAGE
3 min10 points - BeginnerStatistical Functions
Count how many orders shipped with COUNT
Use COUNT to find how many rows contain a numeric value.
COUNT
4 min10 points - BeginnerMath Functions
Total sales for one region with SUMIF
Add up only the rows matching a text condition.
SUMIF
6 min15 points