SCAN
Scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
What it does
Returns an array of accumulated results (running total).
Syntax
SCAN(initial_value, array, lambda)
Arguments
initial_value(value) — Starting value.array(array) — Array to scan.lambda(function) — LAMBDA(accumulator, value).
Examples
Running Total
Cumulative sum.
FORMULA
=SCAN(0, A1:A3, LAMBDA(a,v, a+v))
RESULT
[10; 30; 60]
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | 10 |
| 3 | 20 |
| 4 | 30 |