Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding Across WorkSheets | Excel Worksheet Functions | |||
adding worksheets | Excel Discussion (Misc queries) | |||
adding worksheets together | Excel Discussion (Misc queries) | |||
adding rows to several worksheets | Excel Discussion (Misc queries) | |||
Adding Worksheets | Excel Programming |