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 click-through rate
The situation
Harbor Supply's marketing coordinator reports campaign performance monthly. The platform exports impressions and clicks but not the rate, and comparing raw click counts across campaigns of wildly different sizes tells you nothing.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Campaign | Impressions | Clicks | CTR | |
| 2 | Spring Catalog | 48000.00 | 1440.00 | ||
| 3 | Trade Show Q3 | 12000.00 | 660.00 | ||
| 4 | Reorder Reminder | 9500.00 | 665.00 | ||
| 5 | Search Brand | 22000.00 | 1100.00 | ||
| 6 | Winter Preview | 31000.00 | 620.00 | ||
| 7 |
Who this is for
Recommended next
Related exercises
- BeginnerFormulas
Calculate achievement against target
Divide actual sales by target to get an achievement percentage.
3 min10 points - BeginnerMath Functions
Work out cost per lead
Divide campaign spend by the leads it generated.
4 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