Excel Formulas to Sum the Range with INDEX Function!!
Tags: excelformula, excelformulas
Published: 2021-02-08 10:27:11

---
title: Excel Formulas to Sum the Range with INDEX Function!!
published: true
date: 2021-01-30 09:09:42 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-sum-the-range-with-index/
---

Do you know how to calculate the total value by using the INDEX function? In this guide, we will learn about **how to sum the range with the INDEX function in Excel**. 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)

![Sum with INDEX](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Sum-with-INDEX.png)<figcaption id="caption-attachment-21566">SUM with INDEX</figcaption>

## Generic Formula:

- To calculate the sum of all values in a column or row, you can use the below formula.

**=[SUM](https://geekexcel.com/sum-function/)([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(data,0,column))**

## Syntax Explanations:

- **SUM** – The Excel **[SUM function](https://geekexcel.com/sum-function/)** will help to add the values in the cells.
- **INDEX** – This function helps to return the value at a given position in a range or array. Read more on the **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)**.
- **Data** – It is the input data.
- **Column** – It represents the column number.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Refer to the below example image.

- First, we will give the input values in **Column B** to **Column E**.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Range-20.png)<figcaption id="caption-attachment-21563">Input Range</figcaption>

- Then, apply the above-given formula to the **formula bar** section.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula-31.png)<figcaption id="caption-attachment-21564">Enter the formula</figcaption>

- Finally, press the **ENTER** key, it will display the result as per the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-51.png)<figcaption id="caption-attachment-21565">Result</figcaption>

## Wrap-Up:

In this short tutorial, you can get to know how to **sum the values in a row or column by using the INDEX function in Excel**. If you have any other **ideas** or **question** , do share with us here in the **comments** section below. Thank You!! Click here to know more about **[Geek Excel](https://geekexcel.com/)** and **[Excel Formulas](https://geekexcel.com/excel-formula/)!!**

### Read Ahead:

- **[Excel Formulas to Lookup Multiple Criteria with INDEX and MATCH!!](https://geekexcel.com/excel-lookup-multiple-criteria-with-index-and-match/)**
- **[Excel Formulas to Sum Multiple Columns using Single Criteria!!](https://geekexcel.com/excel-formulas-to-sum-multiple-columns-using-single-criteria/)**
- **[Formulas to Sum the Values from the Last N Columns!!](https://geekexcel.com/excel-formulas-to-sum-the-values-from-the-last-n-columns/)**

### Video Tutorial:

<video id="video-21561-3" width="770" height="374" loop="1" autoplay="1" preload="metadata" controls="controls"><source type="video/mp4" src="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/8pV43RlNxS.mp4?_=3"></source><a href="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/8pV43RlNxS.mp4">https://geekexcel.com/wp-content/uploads/2021/01/8pV43RlNxS.mp4</a></video>