To sum total with the help of INDEX Function, here’s how we do it:
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.
The first thing that we will do is input the SUM Function.
The following formula requires number 1, number 2, and so on…
Now, instead of adding data in the SUM Function, we will input the INDEX Function.
The following formula requires array, row number, and column number.
The array is the sales data in the month of January, February and March of all the products, so the array is C3:E7.
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.
Then comes the column number, as we have mentioned separately in front of Month, we will select cell H5 i.e. 2.
So overall, the formula becomes as follows:
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.
To confirm the answer, let’s use the SUM Function for the month of February.
The numbers in the SUM Function are included in D3:D7.
Now all we have to do is press enter. And BAAAMMM!!! The answer is 279000 which matches our Sum range with INDEX answer.
With this, you can also get sum of first month (January) and third month (March).