Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to sum up the c13 cells in all of the sheets in a workbook
I am developing a master work sheet that incorperates several sheets of
simular info. need a way to total the sums of each sheet. and to be able to have the formula be expandable for new information to be added. ie: adding all the "c13" cells in all the sheets of a workbook. stuck in a rut |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to sum up the c13 cells in all of the sheets in a workbook
Insert a new sheet to the immediate left of the first sheet you want to
include in the sum. Name this sheet Start. Insert a new sheet to the immediate right of the last sheet you want to include in the sum. Name this sheet End. Then: =SUM(Start:End!C13) If you create new sheets and want them to be included in the sum just insert them between the Start sheet and the End sheet. Any sheet between the Start sheet and the End sheet will be included in the sum. -- Biff Microsoft Excel MVP "Liz" wrote in message ... I am developing a master work sheet that incorperates several sheets of simular info. need a way to total the sums of each sheet. and to be able to have the formula be expandable for new information to be added. ie: adding all the "c13" cells in all the sheets of a workbook. stuck in a rut |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying cells between sheets in a workbook | Excel Discussion (Misc queries) | |||
Linking cells on different sheets within a workbook. | Excel Worksheet Functions | |||
add cells together from different sheets within a workbook | Excel Worksheet Functions | |||
Sum of selected cells from different sheets in a new workbook | Excel Worksheet Functions | |||
Max sheets in a workbook or max # of calculated cells | Excel Discussion (Misc queries) |