How can I create a running total in a table? ​

Your formula will need to live in a different column to the values you wish to sum.

• If the values live in column B, create a new column C.

• In column C, write =SUM(B2:B)

This excludes the column name, and sums every value beneath it. It will continue to keep total as you add more rows.