sum data accross multiple worksheets

[tackleberry]

How do I sum columns of data accross multiple worksheets within the excel file and total them in a "total" worksheet????

 

[Brian from Maui]

I think there's more to this question but,

=SUM(Sheet5!A1:A4,Sheet4!A1:A4,Sheet3!A1:A4)

 

[pgc01]

Hi tackleberry
Welcome to the board

To simplify your formulas you can do the following

- organise the worksheets in your workbook so that all the ones with the columns of data you want to add are in sequence

- in the Total worksheet use a 3D formula specifying the first and last woksheets

Ex:

=SUM(Sheet1:Sheet5!A1:A10)

Hope this helps
PGC

 

[tackleberry]

Brian from Maui,
Many many thanks!!!!!

 

[tackleberry]

PGC,
Many many Thanks!!!!!

 

[tackleberry]

Brian from Maui,
many many thanks!!!!