Summ entries using a dynamic sheet name

  • Thread starter Thread starter Raul
  • Start date Start date
R

Raul

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
 
Back
Top