worksheet tite in formula?

[pjgoldstein]

I have this formula in worksheet 1:

=SUMIF('ORG-00'!A4:A54,"T",'ORG-00'!M4:M54)

ORG-00 is worksheet 2

can I use a cell in w1 to populate that portion of the formula allowing
me to change the reference to the worksheet without actually changing
the formula?

Thanks!

 

[Per Erik Midtrød]

I have this formula in worksheet 1:

=SUMIF('ORG-00'!A4:A54,"T",'ORG-00'!M4:M54)

ORG-00 is worksheet 2

can I use a cell in w1 to populate that portion of the formula allowing
me to change the reference to the worksheet without actually changing
the formula?

Thanks!

This page explains two ways to do get the sheet name:
http://www.ozgrid.com/VBA/return-sheet-name.htm

Then you could probably use the indirect function.

Per Erik