Summing values from an undetermined number of sheet

S

smaruzzi

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

Thanks, Stefano
 
S

smaruzzi

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
 
P

Peo Sjoblom

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
 
Top