Skip to content
On this page

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.

running total demo

Built with ❤️ and ☕️ in 🇪🇺.