I had a working summed column in MS excel. Now when I change a value in the column the sum doesnt change. why?

1 ⤊

I had a working summed column in MS excel. Now when I change a value in the column the sum doesnt change. why?

The sum formula previously worked...so I'd change one of the values higher up in the column and the summed total would change. Now..it's just stopped changing..even though the formula is still there

2006-09-28 03:18:53 · 2 answers · asked by Anonymous in Computers & Internet ➔ Software

2 answers

Double check that the formula refers to the entire range you're looking at. Adding cells, copying and pasting stuff, and some other actions may have interfered.

After that, try pressing F9.

2006-09-28 03:49:09 · answer #1 · answered by pharaoh_of_atlantis 2 · 0⤊ 0⤋

excel
tools
options
calculation
automatic (there must be dot on the left)

2006-09-28 03:23:08 · answer #2 · answered by iyiogrenci 6 · 1⤊ 0⤋