I am trying to use range names in a formula. The range name will vary depending on the radio button selected (only one range is valid at a time).
A1 = Bundle1 <--returns the actual name not a cell reference
A2 = Bundle2
A3 = Bundle3
Bundle1 is the name for cells B1:F1 <-- five horizontal cells
Bundle2 = B2:F2
Bundle3 = B3:F3
In cells B10:F10 I have another range (named "Price")
I am using a SUMPRODUCT formula
=SUMPRODUCT(B1:F1,B10:F10) works correctly
=SUMPRODUCT(Bundle1,Price) works correctly (as do all the individual range names
However, if I use radio buttons to select the range I want to use in the formula, I get a #VALUE! answer.
I have the radio button correctly returning the complete range name in cell A5. I've tried =SUMPRODUCT(A5,Price) and it fails. I have tried to 'apply' range name (Insert -> Name -> Apply...) to all the possible cells and nothing but errors.
Any help would be appreciated.
Keith
Bookmarks