| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I add cells from sheet to sheet?
I am trying to add the answer of a sum range of cells to the answer on
another sheet of a range of cells . This is on a worksheet that can not be changed. Can anyone help me? |
|
#2
|
|||
|
|||
|
Lets say you have data in cells A1,A2,A3 in sheet1 and the same in sheet2,
then in any sheet in the workbook enter: =SUM(Sheet1!A1:A3)+SUM(Sheet2!A1:A3) will give you the total sum from both sheets Have a good day! -- Gary's Student "Jennifer M" wrote: I am trying to add the answer of a sum range of cells to the answer on another sheet of a range of cells . This is on a worksheet that can not be changed. Can anyone help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can you view cells from different worksheets in to one sheet,. | Excel Discussion (Misc queries) | |||
| Entering Data in multiple cells on one sheet & having it auto upda | Excel Worksheet Functions | |||
| Copying cells downward on sheet | New Users to Excel | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
Linear Mode
