| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add cells together from different sheets within a workbook
How do I add cells together from different sheets within a workbook
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add cells together from different sheets within a workbook
=sheet1!a1+sheet3!b99+'sheet 999'!x99
or =sum(sheet1!a1,sheet3!b99,'sheet 999'!x99) s6292 wrote: How do I add cells together from different sheets within a workbook -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add cells together from different sheets within a workbook
=Sheet1!A1+Sheet7!D22+Sheet7!N107
-- Biff Microsoft Excel MVP "s6292" wrote in message ... How do I add cells together from different sheets within a workbook |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add cells together from different sheets within a workbook
what if I have multiple sheets in a workbook and I want a number in a cell to
increase by 1 on each consecutive worksheet? "Dave Peterson" wrote: =sheet1!a1+sheet3!b99+'sheet 999'!x99 or =sum(sheet1!a1,sheet3!b99,'sheet 999'!x99) s6292 wrote: How do I add cells together from different sheets within a workbook -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add cells together from different sheets within a workbook
Put 1 in A1 of Sheet1
Then... =sheet1!a1+1 in A1 of Sheet2 =sheet2!a1+1 in A1 of sheet 3 ..... s6292 wrote: what if I have multiple sheets in a workbook and I want a number in a cell to increase by 1 on each consecutive worksheet? "Dave Peterson" wrote: =sheet1!a1+sheet3!b99+'sheet 999'!x99 or =sum(sheet1!a1,sheet3!b99,'sheet 999'!x99) s6292 wrote: How do I add cells together from different sheets within a workbook -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum of selected cells from different sheets in a new workbook | Excel Worksheet Functions | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| Max sheets in a workbook or max # of calculated cells | Excel Discussion (Misc queries) | |||
| Should be able to name Excel sheets based on cells in workbook | Excel Discussion (Misc queries) | |||
Linear Mode
