Skip to content

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


❓  Are you missing something in the documentation?

Ask a question! – The Docs Assistant knows everything about the documentation, and the ideas and feature requests from other users.

Create a ticket on our feedback board. – Let us know if you have an idea for a feature, improvement or think there's something missing.

Request additions to the documentation. – If your questions are not getting answered, let us know and we'll extend the documentation.

Built with ❤️ and ☕️ in 🇪🇺.