| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
summing cell into one
how do i sum up two different cell from different worksheet into a new
worksheet in excel? |
|
#2
|
|||
|
|||
|
Hi
='other_sheet'!A1+'other_sheet'!D3 -- Regards Frank Kabel Frankfurt, Germany hueyncandi wrote: how do i sum up two different cell from different worksheet into a new worksheet in excel? |
|
#3
|
|||
|
|||
|
Place the cursor in a cell in the new worksheet, Enter an "=", click on
worksheet 1 and place the cursor in the desired cell, in the formula window (top of worksheet) enter a + after the cell reference shown, click on worksheet 2 and place the cursor in the desired cell and press enter. You should have something like =Sheet2!C9+Sheet1!E14 as a formula in the new worksheet. Charles O'Neill "hueyncandi" wrote in message ... how do i sum up two different cell from different worksheet into a new worksheet in excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| name of another worksheet in cell for reference | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
