Order boards and a price grid: COUNTIF, SUMIF, $
17 minOrders per status, sales by region, and a price grid that copies across with mixed references.
- Orders per status with COUNTIF
Beginner · 5 min
- Sales by region with SUMIF
Beginner · 5 min
- Price grid for quantities × discounts (mixed references)
Beginner · 7 min
- Excel formulas cheat sheet
Reading, optional · 6 min