Summing values from an undetermined number of sheet
 

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

Thanks, Stefano

Summing values from an undetermined number of sheet
 

Create a Start sheet and an End sheet

=SUM(Start:End!A1)


"smaruzzi" wrote:

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

Thanks, Stefano

Summing values from an undetermined number of sheet
 

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

"Teethless mama" wrote:

Create a Start sheet and an End sheet

=SUM(Start:End!A1)


"smaruzzi" wrote:

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

Thanks, Stefano

Summing values from an undetermined number of sheet
 

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

--
Regards,

Peo Sjoblom


"smaruzzi" wrote in message
...
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

"Teethless mama" wrote:

Create a Start sheet and an End sheet

=SUM(Start:End!A1)


"smaruzzi" wrote:

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

Thanks, Stefano