sumproduct using array of named ranges

If you simply use the formula (adjusting for your ranges)

=SUMPRODUCT(($A$1:$A$4)*(INDIRECT(D1)))

Where D1 contains the name of the range you want to evaluate you can change the value of D1 to another range name and see the result.

Originally Posted by Exceler

I would like to know how to use SUMPRODUCT (or another function) to obtain the sum of the products of a series of values in Row 1 against the values of a series of named ranges in Row 2. I believe I need the syntax for using INDIRECT in an array within the SUMPRODUCT formula; something like:

sumproduct(A1:C1,indirect(A2:C2))

where cells A2:C2 contain names of named ranges.

The plan is to be able to edit the range names to refer to different named ranges, and see the effect of the different named-range values on the sumproduct value.

Thank you.