Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 64
Default 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
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Across WorkSheets computerangel Excel Worksheet Functions 0 July 8th 08 06:08 PM
adding worksheets sorab Excel Discussion (Misc queries) 1 September 5th 06 02:41 PM
adding worksheets together Gary Excel Discussion (Misc queries) 1 June 27th 05 08:26 PM
adding rows to several worksheets Stefanie Excel Discussion (Misc queries) 1 April 5th 05 02:52 PM
Adding Worksheets Peter[_33_] Excel Programming 6 January 16th 04 04:54 PM


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"