The purpose of the index function is to help us find the position of our data in Excel so that we can retrieve it and use it for various purposes. In this example, we will be using the Index function to find the position of our monthly sales figures from table 1 so that we can summarise it into quarterly figures. Continue reading “Fusing Together The SUM and Index Function | Excel | Tutorial”
Simplify Tasks 