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.