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