Forum Discussion
How to workaround circular ref in array formula?
Trying to make an excel table auto calculates when new row as been added Column A, 1 5 -7 6 Column B would be the sum of the value in Column A of the current row + the value of column B from ...
The SCAN function was added to Excel to handle accumulation (This function cannot be placed in a table).
arr being a dynamic range
=SCAN(0,arr,LAMBDA(a,v,a+v))