ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding worksheets (https://www.excelbanter.com/excel-programming/296511-adding-worksheets.html)

mike clay

Adding worksheets
 
i am trying to add the sheet 1 K12 to sheet 2 k12 and get
a total and thin add sheet 2 k12 to sheet 3 k12 and get a
total and so on and so on.
if anyone can help please let me know
mike

Pete McCOsh

Adding worksheets
 
Mike,

=sum('sheet1:sheet2'!K12)

you can modify this as required. The sum will add the
total of the range on all sheets between the first and
second named in the formula.

Cheers, Pete

-----Original Message-----
i am trying to add the sheet 1 K12 to sheet 2 k12 and get
a total and thin add sheet 2 k12 to sheet 3 k12 and get a
total and so on and so on.
if anyone can help please let me know
mike
.



All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com