LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,124
Default what formula do I use to add sums from other worksheets to a sum s

suggest they are dummies and you actually sum the ones in between.
=sum(sheetfirst:sheetlast!a1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Louise" wrote in message
...
What formula do I use to add sums from multiple worksheets into a summary
sheet, and how many sheets can I add?


 
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
Sums from different worksheets Botts Excel Worksheet Functions 0 August 1st 07 06:40 AM
Help With A Formula That Sums Items In A Column Gatsby Excel Discussion (Misc queries) 2 January 25th 07 12:04 AM
Need a formula that sums a column but could exclude some cells Watercolor artist Excel Worksheet Functions 4 August 4th 05 10:03 AM
How come some worksheets automaticly change sums and others don't. T.D. Excel Discussion (Misc queries) 2 January 29th 05 08:41 PM
formula that meets two criteria and sums? C Cooper Midland Excel Discussion (Misc queries) 2 December 14th 04 02:49 PM


All times are GMT +1. The time now is 03:27 AM.

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

About Us

"It's about Microsoft Excel"