Summing values from an undetermined number of sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a smart way to sum numbers not knowing the last sheet i should
consider in the sum?

Thanks, Stefano
 
Thnaks, for the suggestion, but I'd like to understand if i can create a
dynamic formula where the last sheet to be considered is calculated
programmatically. I explored INDIRECT() but apparently it doesn't work with
aggregate functions.
Any workaround?

Thanls, Stefano
 
You cannot use a dynamic formula when it comes to sheets and future sheets.
Best way is to use dummy sheets and always add future sheets in-between the
dummy sheets described in the answer you received
 
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

Sum Values from different column 1
Time Sum in Excel 1
Changing Sum Range Based on Date Chosen from Drop Down List 1
HELP!! How to formula the "sheet" link 2
Macro/Forumula to SUM values from Sheet that does not always exist 1
How to sum one cell across workbook if nr of worksheets is variabl 2
SUM 3D Reference using variable sheet limits 5
Creating a text string by reading content in multiple cells 3

Back
Top