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