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

1. ## Reference worksheet name as a cell value in another worksheet

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. 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. 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
•