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
Principiante · 5 min
- Sales by region with SUMIF
Principiante · 5 min
- Price grid for quantities × discounts (mixed references)
Principiante · 7 min
- Excel formulas cheat sheet
Lectura opcional · 6 min