✦Template Printable Ideas Insights

Master Running Totals: Step-by-Step Google Sheets Guide

By

Ever wondered how to keep track of running totals in Google Sheets? Perhaps you're managing a budget, tracking sales, or simply want to update a total automatically as data changes. Whatever your reason, we've got you covered. In this guide, we'll walk you through the process, step by step, to create a running total in Google Sheets.

Before we dive in, ensure your Google Sheets is up to date. This guide uses the newest version (November 2021), so you may need to update your sheets to follow along accurately. Now, let's get started!

Understanding Running Totals

A running total is a cumulative sum of numbers, constantly updated as new data is added or existing data changes. Understanding this concept is crucial before delving into how to create one in Google Sheets.

How to Calculate Running Total in Google Sheets
How to Calculate Running Total in Google Sheets
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
Yearly Running Log Google Sheets Template: Track Pace & Intensity (Digital File)
Yearly Running Log Google Sheets Template: Track Pace & Intensity (Digital File)

For instance, consider tracking monthly sales. Each month's sales would contribute to the running total, updating automatically whenever a new month's sales are entered.

Preparing Your Data

First, ensure your data is organized and formatted correctly. For our example, let's say we have sales data from January to March, with sales figures entered manually into Column B (cells B2 to B5).

How to Create a Running Total in a Spread Sheet - Google Docs or Excel
How to Create a Running Total in a Spread Sheet - Google Docs or Excel
6 Crazy Google Sheets Formulas You Should Know
6 Crazy Google Sheets Formulas You Should Know
the google sheets has hidden gems you're not using on your webpages
the google sheets has hidden gems you're not using on your webpages

Before proceeding, double-check if any cells are blank or contain non-numeric values. Running totals won't work with such data, so ensure all cell contents are numbers.

Using SUM to Calculate Running Totals

Now that your data is ready, we'll use the `SUM` function to create a running total. As new data is added, or existing data changes, the running total will update automatically.

To do this, select the first cell where you want the running total to appear (e.g., cell C2). Then, in the formula bar, enter the following formula: `=SUM(B$1:B2)`

10 Essential Google Sheets Formulas Everyone Should Know
10 Essential Google Sheets Formulas Everyone Should Know
Basic Formatting in Google Sheets
Basic Formatting in Google Sheets
How to use Google Sheets: A beginner's guide | Zapier
How to use Google Sheets: A beginner's guide | Zapier
the 13 google sheets shortcuts list is shown in green and has white writing on it
the 13 google sheets shortcuts list is shown in green and has white writing on it
Best method to do running totals in #Excel
Best method to do running totals in #Excel
the google sheets are in green and white
the google sheets are in green and white

In this formula, `B$1:B2` refers to the range of cells we want to sum. The dollar sign ($) ensures the range doesn't change even if you copy or drag the formula across.

Automatically Filling Down Running Totals

Now that we've entered the formula, the cell containing the running total (C2) displays the sum of the visible cells in Column B. But how do we get this to fill down automatically as new rows are added?

To do this, simply click and drag the cell with the running total (C2) down to the last row where you want the running total to appear. As you add new rows or update existing data, the running total will auto-update.

Google Sheets Checklists
Google Sheets Checklists
ULTIMATE Digital Running Log Spreadsheet Template for Google Sheets - Brown, Running Tracker, Running Log, Running Spreadsheet
ULTIMATE Digital Running Log Spreadsheet Template for Google Sheets - Brown, Running Tracker, Running Log, Running Spreadsheet
How to Create Progress Bars in Google Sheets (Step-by-Step)
How to Create Progress Bars in Google Sheets (Step-by-Step)

Applying Custom Formats

To make the running total stand out, you can apply custom formatting. Select the cells containing the running totals, then click on the number formatting icon in the toolbar (found in the 'Format' menu) and choose the desired format.

For example, you might want to display running totals in thousands or use currency formatting. Google Sheets allows for a wide range of customizations, so feel free to experiment.

Creating Running Totals for Multiple Rows or Columns

What if you want to create running totals for multiple rows or columns? You can do this by copying and adjusting the original `SUM` formula.

For instance, if you want a running total for Column B (sales data for January to March) and Column C (costs), enter the following formula in cell D2: `=SUM(B$1:C2)`

Then, copy and paste this formula into the rest of the running total column (D). The running total will now include values from both columns B and C.

Congratulations! You now know how to create running totals in Google Sheets. Whether you're tracking sales, managing a budget, or need a quick sum of a range, this skill will come in handy. Happy totaling!