Summed Cell won't update as I add data into the cell range...

G

Guest

I have a simple sum function at the bottom of a column:
=SUM(D4:D68)

About half of the cells in that range are empty. When I add data to the
empty cells the SUM total in cell D69 does not update. It remains static. I
have to manually re-SUM every time. I've never had this problem before - I'm
sure some formatting issue but I don't know what. Would appreciate any help.
Thanks.
 

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

Automatic update to SUM formula cell references. 6
autosum refusal to sum highlighted range 4
formula to make the value in a cell, to a row in a sum function 5
Add alternate cells in column and sum 4
Summing a range of cells based on criteria in another range 2
Summing dynamic range 7
Summing large number of non contiguous cells evenly distributed 5
summing adjacent data in a worksheet 3

Top