Practice challenge
Count campaigns above target
#7
3 attempts remaining
BeginnerMarketingTarget D2
A marketing team wants to count campaigns with more than 500 clicks.
Write a formula for D2 that counts click values greater than 500.
Count campaigns above target
Swipe horizontally to view the full table.
| A | B | C | D | |
|---|---|---|---|---|
| # | Campaign | Clicks | Spend | Campaigns > 500 |
| 2 | Search | 620 | 420 | blank |
| 3 | Social | 480 | 300 | blank |
| 4 | 710 | 110 | blank | |
| 5 | Display | 250 | 190 | blank |