Indirect and Sum across Multiple Sheets

  • Thread starter Thread starter gr
  • Start date Start date
G

gr

I have been hunting for a way to do this for a few hours now. It
appears that this combination is only good on 2d ranges, not 3d. But
I'll ask again anyway.

I have a formula that works fine
=SUM(Start:End!F181)

But what I want to do is change the 181 value (or possibly the F181)
to a variable that will be stored in a cell on the same sheet as this
formula. (which is a totals page)

Is this possible?

TIA
Guy
 
Put the full list of sheet names in M1:Mn, and use

=SUMPRODUCT(N(INDIRECT(M1:Mn&"!"&E1)))

obviously replace n by the number of sheets.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
You must log in or register to reply here.

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

Indirect function across sheets 5
Sum Indirect function through multiple sheets 2
Sum across worksheets with indirect 5
INDIRECT function 2
Count Check Boxes across Sheets 3
Using the INDIRECT function across multiple worksheets 1
Sum across multiple worksheets 4
Indirect and sumif functions with multiple workbooks 1

Back
Top