First formulas: SUM, a filtered list, text pieces
15 minYour first total with SUM, a filtered list counted with SUBTOTAL, and a product code cut into parts.
- Total revenue with SUM
Débutant · 3 min
- Filter one region and count visible rows with SUBTOTAL
Débutant · 6 min
- Extract category, year and serial from SKU
Débutant · 6 min