Below is just a simple example of what is occurring for me in Excel.
[TABLE="width: 193"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Number1[/TD]
[TD]Number2[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]72[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]58[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
</tbody>[/TABLE]
The Total column is my formula (=sum(a1+b1) in row 1, =sum(a2+b2) in row 2 etc.). When I copy the formula down it shows 18 as the results for each row even though that's clearly not the case. Any ideas what is going on here? This just started to happen the other day.
[TABLE="width: 193"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Number1[/TD]
[TD]Number2[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]72[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]58[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[/TR]
</tbody>[/TABLE]
The Total column is my formula (=sum(a1+b1) in row 1, =sum(a2+b2) in row 2 etc.). When I copy the formula down it shows 18 as the results for each row even though that's clearly not the case. Any ideas what is going on here? This just started to happen the other day.