![]() |
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 |
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