Summ entries using a dynamic sheet name

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
 
J

Jacob Skaria

Try

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking up next available number 3
Sum cells using criteria from a row and a column 2
Using SUMPROD and trying SUBSTITUTE, ELIMINATE or TAKE the last VE 0
SUMPROD and OTHER FUNCTIONS!!! VERY URGENT 3
Vlookup and return sheet name also 2
Visio: copy text of a master shape to User-define Cells (Variable) 0
Insert name and adress from a list in a word document 1
Finding dynamic maxima 9

Top