IntermediateData Analysis
Total marketing spend for one channel
Add up spend for a single channel out of a mixed campaign list.
SUMIF
7 min25 points
Real situations from working spreadsheets — sales targets, commission tiers, messy exports, aged invoices. Numbered in recommended order: start at 1 and work down, or filter to what you need.
1 exercise — Intermediate · Data Analysis · for Marketing
| # | Exercise | Functions | Difficulty | Time | Status |
|---|---|---|---|---|---|
| 59 | Total marketing spend for one channelHarbor Supply — campaign spend by channel | SUMIF | Intermediate | 7 min | 25 pts |