Forum Discussion
Simple Excel--WHAT has changed in new version?
A12 is the sum of Column A. B12 is the sum of Column B. The formula =Sum(A12+B12) returns 0. All cells are formatted as numbers. Can a cell containing a calculation no longer be referenced in the for...
When we download and open the example file, Excel notes a circular reference in E12. There is a similar circular reference in D12. The formulas are:
D12: =SUM(D2:D12)
E12: =SUM(E2:E12)
When there are circular references, Excel aborts the worksheet recalculation. That might leave some cells in inconsistence states.
That is why the calculations in D13 and E13 return zero.
The remedy is to eliminate the circular references. One way:
D12: =SUM(D2:D11)
E12: =SUM(E2:E11)
Alternatively, the following formula allows you to insert rows above the SUM row.
D12: =SUM(D$2:INDEX(D:D,ROW()-1))
Copy D12 into E12
THANK you. Oops, I used autosum to add up the column and should have checked the final formula. Hopefully, now the more complicated formulas will also work.