Sum multiple worksheets

[Guy]

I know I can add differnt worksheet cells together, but if
i have a spreadsheet with multiple w/s. If they have the
same format can I use a command to add cells from the
different sheest without having to go into each w/s and
select each cell?

 

[Ron de Bruin]

Hi Guy

Add two dummy sheets(empty sheets)with the name start as the first sheet
and one with the name end as the last sheet of your workbook.
this are empty sheets!!!

And use this formula

=SUM(start:end!A1)