I have a spreadsheet that uses the following formula to retrieve the
information from separate sheet. I would like to replace the reference to
"Resource1" with a reference to a call on the current sheet that contains the
tab name.

I have tried the "INDIRECT" function, but I cannot seem to tget it to work
for me.

=SUMIF(Resource1!$A$3:$A$1001,"999999",Resource1!E $3:E$1001)

Any assistance is greatly appreciated.

Thank you

Try

=SUMIF(INDIRECT("'" & A1 & "'!$A$3:$A$1001"),"999999",
INDIRECT("'" & A1 & "'!$E$3:$E$1001"))

If this post helps click Yes
---------------
Jacob Skaria


"Raul" wrote:

I have a spreadsheet that uses the following formula to retrieve the
information from separate sheet. I would like to replace the reference to
"Resource1" with a reference to a call on the current sheet that contains the
tab name.

I have tried the "INDIRECT" function, but I cannot seem to tget it to work
for me.

=SUMIF(Resource1!$A$3:$A$1001,"999999",Resource1!E $3:E$1001)

Any assistance is greatly appreciated.

Thank you