To sum total with the help of INDEX Function, here’s how we do it:

Example:

INDEX Formula

As you can see in the image above, we can observe that products and sales made in the month of January, February and March are given.

Previously: Calculate the total number of rows in a range with ROWS Formula

INDEX Formula

The first thing that we will do is input the SUM Function.

=SUM(

The following formula requires number 1, number 2, and so on…

INDEX Formula

Now, instead of adding data in the SUM Function, we will input the INDEX Function.

=INDEX(

The following formula requires array, row number, and column number.

INDEX Formula

The array is the sales data in the month of January, February and March of all the products, so the array is C3:E7.

INDEX Formula

Then comes the point of row number, if we do not want to add a specific row number then to leave the same or ignore the same, all we can do is write 0.

INDEX Formula

Then comes the column number, as we have mentioned separately in front of Month, we will select cell H5 i.e. 2.

INDEX Formula

So overall, the formula becomes as follows:

=SUM(INDEX(C3:E7,0,H5))

INDEX Formula

Now all we have to do is press enter.

And BAAAMMMM!!! The sum total of the 2nd month in the data, i.e. February is 279000.

INDEX Formula

To confirm the answer, let’s use the SUM Function for the month of February.

INDEX Formula

The numbers in the SUM Function are included in D3:D7.

INDEX Formula

Now all we have to do is press enter. And BAAAMMM!!! The answer is 279000 which matches our Sum range with INDEX answer.

INDEX Formula

With this, you can also get sum of first month (January) and third month (March).

INDEX Formula