Formulas to calculate the running total from a range in Excel!!
Tags: excelformula, excelformulas
Published: 2020-11-21 09:01:41

---
title: Formulas to calculate the running total from a range in Excel!!
published: true
date: 2020-11-21 08:51:46 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-calculate-the-running-total-from-a-range-in-excel/
---

Here, we will discuss the **formulas to calculate the running total from a range in Excel Office 365**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to calculate running total](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-calculate-running-total.png)](https://geekexcel.com/formulas-to-calculate-the-running-total-from-a-range-in-excel/formulas-to-calculate-running-total/#main)<figcaption id="caption-attachment-17797">Formulas to calculate running total</figcaption>
## General Formula:

- To calculate the running total from a range in Excel, use the below formula.

**=[SUM](https://geekexcel.com/sum-function/)([$A1](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/):A1)**

## Syntax Explanations:

- **SUM** – In Excel, the [**SUM Function**](https://geekexcel.com/sum-function/) adds values in the cells.
- **Absolute Reference($)** – The [**Absolute Reference**](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/) is an actual fixed location in a worksheet.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Range** – It represents the input range from your workbook.

## Example:

- In the below example, we will show how to calculate the running total from a range.
- First, we will give the input values in **Column C**.
- Then enter the given formula in the formula bar section.
- Finally, it will calculate the running total and display the result as shown in the below image.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-53.png)<figcaption id="caption-attachment-17796">Example</figcaption>

## Closure:

From this article, you can get some clarification on the **formulas used to calculate the running total from a range in Excel Office 365**. Hope that this article is useful to you. If you have any **suggestions,** don’t forget to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Count Numbers by Range with COUNTIFS Function!!](https://geekexcel.com/excel-formulas-to-count-numbers-by-range-with-countifs-function/)**
- **[Excel Formulas to Count Total Matches in Two Ranges!!](https://geekexcel.com/excel-formulas-to-count-total-matches-in-two-ranges/)**
- **[Formulas to Count Multiple Criteria and OR Logic with COUNTIFS!!](https://geekexcel.com/formulas-to-count-multiple-criteria-and-or-logic-with-countifs/)**
- [**Formulas to Count with COUNTIF Function in Excel Office 365!!**](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/)