View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mumsy Mumsy is offline
external usenet poster
 
Posts: 1
Default Column "SUM" Not SUMming

I am having a problem with an often used spreadsheet. I have a column of
figures that starts with a positive figure and then subtracts various
entries. The column is 39 rows long and I used the Greek "SUM" icon to
figure the answer. This was working fine until I noticed, just yesterday,
that it wasn't automatically changing the total as I changed the entries. If
I re "SUM" it it's fine, but it won't do it automatically. I use this sheet
from month to month and I don't think I've "locked" any of the cells. Is
there something that I'm doing wrong?

--
Thanks