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
Iniciante · 3 min
- Filter one region and count visible rows with SUBTOTAL
Iniciante · 6 min
- Extract category, year and serial from SKU
Iniciante · 6 min