Free Excel training videos

Data Analysis

Index Function


INDEX(Array,Row Number,Column Number)

As illustrated below the formula INDEX(sales,2,3) returns the sales of 'TFT monitors 17" ' in March. The parameter 'sales' is the named range 'B4:G9'.

The index function also makes it easy to access an entire column or row of an array. For example, we can calculate the total sales in the month of April in our sales data by using the formula: SUM(INDEX(sales,0,4)) where the row is set to '0' and now the complete column '4' is made accessible. You could also use the formula by making the row number=4 and the column number=0. This would calculate the total sales of the 'Pen Drives (64 MB)'! 


Further Reading on Index Function
Free Excel training videos