Adding up multiple spreadsheets in one workbook please

[Jonny1964]

Hello, I am sure this is very simple, I just don't know hwo to do it.
I have 12 worksheets for mileage each month and on the 13th worksheet I want to add up the same cell from each worksheet to get a total for the year. I want to add up cell E6 from 12 seperate spreadsheets and display in one total box on the 13th - please can someone tell me how to do this? Thank you in advance! Jon

[icestationzbra]

there is something called 3D function, which you can read more about here:

http://office.microsoft.com/en-us/ex...010102346.aspx

if your 12 sheets are contiguous (in a straight sequence, adjacent to each other, no gaps), then you could use SUM in 3D fashion on the 13th sheet:

Please Login or Register  to view this content.

[Jonny1964]

Thank you very much for the link. Fixed!