Order boards and a price grid: COUNTIF, SUMIF, $
17 минOrders per status, sales by region, and a price grid that copies across with mixed references.
- Orders per status with COUNTIF
Начальный · 5 мин
- Sales by region with SUMIF
Начальный · 5 мин
- Price grid for quantities × discounts (mixed references)
Начальный · 7 мин
- Excel formulas cheat sheet
Чтение, необязательно · 6 мин