INDIRECT inside a SUMPRODUCT
Using INDIRECT function is one of the very useful feature in EXCEL. Used heavily whenever we need to create a summary for our report. But using it inside a SUMPRODUCT function is bit tricky.
The formula is
Here i have the name of the sheet (For eg: PeopleDetails) in the B6. Then i need to select the range from C6 to C21 in PeopleDetails. And then i need to multiply the values with the values in sheet Rates.