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

=SUMPRODUCT(INDIRECT(B6&"!C6:C21"),Rates!C6:C21)

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.

No comments yet... Be the first to leave a reply!

Leave a Reply