Results 1 to 3 of 3

Thread: Reference worksheet name as a cell value in another worksheet

  1. #1

    Reference worksheet name as a cell value in another worksheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello. This is my first time at this website. I hope anyone can help me solve this issue. I have a formula like this: =SUMIF('2429'!$C$14:$C$363,BAT!$E48,'2429'!$F$14:$F$364). Because it has to reference a sheet "2429". This sheet populate based on cell C3 of worksheet BAT. Everytime C3 is changing the sheet will disappear and populate another sheet. I want this formula apply to all the sheet as possible. Is there a way that I can reference the number 2429 in the formula above to something else so I don't have to worry about changing the sheet. Thank you.

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    If I understand your question correctly, then this should do it:
    =SUMIF(INDIRECT(C3&"!$C$14:$C$363"),BAT!$E48,INDIRECT(C3&"!$F$14:$F$364"))

    If this doesn't do what you need, then I suggest you upload a sample workbook, so we can see exactly what you are trying to do.

  3. #3
    Neophyte nmhung49's Avatar
    Join Date
    Sep 2012
    Location
    Vietnam
    Posts
    1
    Articles
    0
    Try this
    =SUMIF(INDIRECT("'"&C3&"'!$C$14:$C$363"),BAT!$E48,INDIRECT("'"&C3&"'!$F$14:$F$364"))

Posting Permissions

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