| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copied formula has correct cell reference, but result of original
I copied a sum formula from cell a to cell b.
The result in cell b is the sum formula with correct cell references, but it displays the sum result from cell a. e.g. the sum in cell a is 6, the sum in cell b is 4, but 6 is displayed. |
|
#2
|
|||
|
|||
|
Toolsoptionscalculation set to automatic
Regards, Peo Sjoblom "lvito" wrote in message ... I copied a sum formula from cell a to cell b. The result in cell b is the sum formula with correct cell references, but it displays the sum result from cell a. e.g. the sum in cell a is 6, the sum in cell b is 4, but 6 is displayed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| cell reference in a formula is called | Excel Discussion (Misc queries) | |||
| A cell reference in a formula changing | Excel Worksheet Functions | |||
| How is it that a cell can transfer the correct formula, but the w. | Excel Discussion (Misc queries) | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
Linear Mode
