Formatted Table Running Total  Custom Function

My old post (6 years ago) can be found below.

https://a4accounting.com.au/running-total-in-a-formatted-table/

Here is a more elegant solution.

This uses the SUM and INDEX functions together.

The INDEX function returns a reference to the first cell of the column.

The @ with the column then refers to the current row in the column.

The SUM adds up between the two references.

The formatted table automatically copies the formula down the column.

Custom Function

To simplify the process a custom function can be used. Here is the LAMBDA test formula.

=LAMBDA(tblCol,SUM(INDEX(tblCol,1):@tblCol))([Amount])

Here is the range name definition.

Here is the custom function is action.

This custom function will work with a normal range but you need to copy the formula down.

For a normal range you would use the SCAN and LAMBDA functions to create a Spill range.