First formulas: SUM, a filtered list, text pieces
15 минYour first total with SUM, a filtered list counted with SUBTOTAL, and a product code cut into parts.
- Total revenue with SUM
Начальный · 3 мин
- Filter one region and count visible rows with SUBTOTAL
Начальный · 6 мин
- Extract category, year and serial from SKU
Начальный · 6 мин