Tips & Tricks 206 – Running Total Using Dynamic Arrays Posted on August 5, 2025August 19, 2026 by Vijay Verma Running Total for a Range = SCAN(, A2:A10, SUM) Running Total for a Filtered Range = SUBTOTAL(9, TAKE(A2:A10, SEQUENCE(ROWS(A2:A10))))
