copied formula has correct cell reference, but result of original

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to add numbers in same cell? 2
Time Sum in Excel 1
How do I sum cells that have values from a text formula? 4
SUMIF with criteria "<>" & "=" 4
formula to make the value in a cell, to a row in a sum function 5
Excel formula, sum the value cell and if empty cell left blank 0
SUM formula after HLOOKUP result true 9
Copying formulas - problem with the sum 1

Top