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.
Reference worksheet name as a cell value in another worksheet
- Thread starter tdnguyen
- Start date
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.
=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.
