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.
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.
Tools>options>calculation set to automatic
Regards,
Peo Sjoblom
"lvito" <lvito@discussions.microsoft.com> wrote in message
news:1EC21E19-3527-43EA-A4D2-AFA579F4B747@microsoft.com...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks