Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Adding numbers from a list over a specific value | Excel Discussion (Misc queries) | |||
Adding specific cells in column | Excel Worksheet Functions | |||
adding and divideing by a the number of cells! | Excel Worksheet Functions | |||
how to format only specific characters or numbers within each cellwithin a range of cells | Excel Discussion (Misc queries) |