How can I get auto sum of column when new figures are added Dave 18.07.2006 14:12:02 I have put in formula to total a column of figures, it has empty cells for new items to be entered as they occur. It used to total in new items automatically, now it will not total in new items. It is a Monthly spreadsheet. I used" create a copy "to make blank copies to use for following months. I made changes to existing sheets as I needed to by using CTRL key and clicked on each future month. this may be why it will not total as new figures are added.

Re: How can I get auto sum of column when new figures are added "BruceM" <bamoob[ at ]yawwhodawtcalm.not> 18.07.2006 14:36:08 You should ask this question in an Excel newsgroup. If you came here through the Microsoft web site, be aware that it is not as clear as it should be about directing people to appropriate forums. This one is for Microsoft Access, a relational database program. "Dave" <Dave[ at ]discussions.microsoft.com> wrote in message news:40C3455A-DEB8-4FFA-AA5E-D1514E7E3743[ at ]microsoft.com... [Quoted Text] >I have put in formula to total a column of figures, it has empty cells for > new items to be entered as they occur. It used to total in new items > automatically, now it will not total in new items. It is a Monthly > spreadsheet. I used" create a copy "to make blank copies to use for > following > months. I made changes to existing sheets as I needed to by using CTRL key > and clicked on each future month. this may be why it will not total as new > figures are added.