FUNCTION CATALOGUE / LOGICAL / ARRAY
SCAN Excel function
Returns intermediate accumulation results.
Correct sentence to use
Calculate a running [operation] over [array].
Modify this query in PlainFormula →Example formula
=SCAN(0,A2:A10,LAMBDA(a,v,a+v))
Returns intermediate accumulated values.
Syntax
SCAN([initial_value], array, lambda)
Argument signature: [initial_value], array, lambda
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.