Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Adding numbers from specific cells in a number of sheets


Hi.

I have a summary sheet that in cell c1 should add up the value of cell
c1 in ten different sheets and do the same in two hundred other cells.

The other sheets are copies the summary sheet however they contain the
actual data.

I could do it manually by summing each one, but if I delete or add a
sheet I can start over.

What would be the easiest way to do this?

/Mølller


--
c991257
------------------------------------------------------------------------
c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549
View this thread: http://www.excelforum.com/showthread...hreadid=568084

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 964
Default Adding numbers from specific cells in a number of sheets

I'd suggest adding two new worksheets to your workbook. Name the first one
"Begin" and the second one "End". Move the "Begin" sheet before all of your
data sheets. Move the "End" sheet after all of your data sheets, but before
your summary sheet. Leave these new sheets completely blank, then hide them.

Then, on the Summary sheet use the formula:

=SUM(Begin:End!C1)

This adds all the C1 cells from the sheets between Begin and End. Then,
whenever you add a new sheet, just make sure it is between Begin and End,
then the Summary formulas will include it without having to be updated.

HTH,
Elkar


"c991257" wrote:


Hi.

I have a summary sheet that in cell c1 should add up the value of cell
c1 in ten different sheets and do the same in two hundred other cells.

The other sheets are copies the summary sheet however they contain the
actual data.

I could do it manually by summing each one, but if I delete or add a
sheet I can start over.

What would be the easiest way to do this?

/Mølller


--
c991257
------------------------------------------------------------------------
c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549
View this thread: http://www.excelforum.com/showthread...hreadid=568084


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Adding numbers from specific cells in a number of sheets


perfect. Thanks

/Møller


--
c991257
------------------------------------------------------------------------
c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549
View this thread: http://www.excelforum.com/showthread...hreadid=568084

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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Adding numbers from a list over a specific value Herd96 Excel Discussion (Misc queries) 4 May 15th 06 02:21 PM
Adding specific cells in column MG Excel Worksheet Functions 1 February 23rd 06 11:09 PM
adding and divideing by a the number of cells! nerdman Excel Worksheet Functions 7 December 14th 05 07:20 PM
how to format only specific characters or numbers within each cellwithin a range of cells Colleen Excel Discussion (Misc queries) 4 September 12th 05 10:04 PM


All times are GMT +1. The time now is 02:05 PM.

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"