BeginnerMath Functions
Total a month of sales with SUM
Add up a column of daily sales figures to get the monthly total.
SUM
3 min10 points
Calculate a funnel conversion rate
The situation
Harbor Supply's distributor sign-up funnel loses people at every step. Marketing has the raw counts at each stage but not the drop-off, and the counts alone make the biggest stage look like the healthiest one.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Stage | People | Conversion | ||
| 2 | Visitors | 12000.00 | |||
| 3 | Leads | 480.00 | |||
| 4 | Applications | 156.00 | |||
| 5 | Approved distributors | 96.00 | |||
| 6 |
Who this is for
Recommended next
Related exercises
- BeginnerMath Functions
Calculate click-through rate
Express clicks as a percentage of the impressions that earned them.
4 min10 points - BeginnerFormulas
Calculate achievement against target
Divide actual sales by target to get an achievement percentage.
3 min10 points - BeginnerMath Functions
Total a month of sales with SUM
Add up a column of daily sales figures to get the monthly total.
SUM
3 min10 points