| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum data in multiple cells from two worksheets
I have been unsuccessful at attempting to sum data in two worksheets
(multiple cells). I have tried using the 3-D reference but apparently I am not understanding the process. I want to total the data in page 16 (F6:F53) and page 17 (F6:F47) into cell F48 on page 17. Can someone give me step by step instructions starting with what is expected as a name in the "Names in workbook" in the 3-D reference function (if this is the how I need to get my desired result? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum data in multiple cells from two worksheets
page 16
page 17 Are those your actual sheet names? Try this: =SUM('page 16'!F6:F53,F6:F47) -- Biff Microsoft Excel MVP "ccwies" wrote in message ... I have been unsuccessful at attempting to sum data in two worksheets (multiple cells). I have tried using the 3-D reference but apparently I am not understanding the process. I want to total the data in page 16 (F6:F53) and page 17 (F6:F47) into cell F48 on page 17. Can someone give me step by step instructions starting with what is expected as a name in the "Names in workbook" in the 3-D reference function (if this is the how I need to get my desired result? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum data in multiple cells from two worksheets
Hi ccwies
If you just want to sum the ranges in different sheets, try this In Cell F48 of Sheet17, place this formula =SUM(Sheet16!F6:F53,Sheet17!F6:F47) Does this do waht you want? ======================= Pls click Yes if this has help you Thank You cheers, Francis I may be able to provide you a solution, there would be better solutions from others. "ccwies" wrote: I have been unsuccessful at attempting to sum data in two worksheets (multiple cells). I have tried using the 3-D reference but apparently I am not understanding the process. I want to total the data in page 16 (F6:F53) and page 17 (F6:F47) into cell F48 on page 17. Can someone give me step by step instructions starting with what is expected as a name in the "Names in workbook" in the 3-D reference function (if this is the how I need to get my desired result? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to make a macro to clear multiple cells from multiple worksheets? | Excel Worksheet Functions | |||
| enter data once... copy to multiple cells on other worksheets | Excel Discussion (Misc queries) | |||
| Display data from multiple worksheets' cells in one worksheet | Excel Worksheet Functions | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
| How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions | |||
Linear Mode
