+ Reply to Thread
Results 1 to 2 of 2

Variable Range Names in Formulas

  1. #1
    Registered User
    Join Date
    10-13-2006
    Posts
    5

    Variable Range Names in Formulas

    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

  2. #2
    Registered User
    Join Date
    10-13-2006
    Posts
    5
    I was able to figure it out using the INDIRECT function.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1