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