Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Indirect (97;SR2)

    I have an issue with a formula usind INDIRECT. My formula is: =SUMIF(Old!$E$2:$E$50000,E7,INDIRECT((ADDRESS(2,COLUMN(INDIRECT(Old!AE1)),1,TR UE)&":"&ADDRESS(15,COLUMN(INDIRECT(Old!AE1))))))

    There are two worksheets the first named "Old" (don't ask why) and the other "Sheet2". The sheet named "Old" contains data and "sheet2" containing the formula mentioned above. My problem is that I can not pass the "Old" sheet reference to the bold portion of text in the formula. It references the range in "Sheet2" instead of sheet "Old". I can not name a range in sheet "Old" to resolve the issue. I thought the bold text should look something like Old!INDIRECT((ADDRESS..blah blah blah

    Thanks,
    John

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Indirect (97;SR2)

    Well I'll be darned. This works: INDIRECT((ADDRESS(2,COLUMN(INDIRECT(Old!AE1)),1,TR UE,"Old")&":"&ADDRESS(15,COLUMN(INDIRECT(Old!AE1))))))

    John

Posting Permissions

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