I had an issue trying to use excel to calculate the running total and display in a new cell in the adjacent column like below
The trick here is select the column you want to calculate the running total, assign a name and format it as a table, and in the adjacent column ,here C2 use the formula
=SUM(B$1:[@Number]), ola you have the running total .
