Hi
And as a third alternative, create 2 dummy extra sheets called First and Last.
Drag these to positions before your first real sheet and after your last
real sheet and use
=SUM(First:Last!A1)
Of course, the sheet with the formula must be outside of the "sandwich"
created by First and Last.

Regards

Roger Govier


RagDyer wrote:
Considering that Bob answered for the worst case scenario, where you have
custom named all your sheets, here's for the best case scenario, where you
have all default (Sheet1, Sheet2, ...etc.) sheet names:

=SUM(SHEET1:SHEET70!A1)