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
Work out cost per lead
The situation
Harbor Supply's marketing budget is being reallocated for next quarter. Spend and leads are recorded per campaign, but nothing shows what each lead actually cost — which is the only basis on which the reallocation can be argued.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Campaign | Spend | Leads | Cost per lead | |
| 2 | Spring Catalog | $4,800 | 120.00 | ||
| 3 | Trade Show Q3 | $12,500 | 85.00 | ||
| 4 | Reorder Reminder | $2,200 | 140.00 | ||
| 5 | Search Brand | $6,400 | 160.00 | ||
| 6 | Winter Preview | $3,100 | 40.00 | ||
| 7 |
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 - BeginnerExcel Basics
Work out gross margin per order
Subtract cost from revenue to find what each order actually earned.
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