| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column "SUM" Not SUMming
Tools/ Options/ Calculation
Make sure it's set to Automatic, nor Manual. -- David Biddulph "Mumsy" (donotspam) wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column "SUM" Not SUMming
Let's rule out the obvious first... click Tools/Options on the menu bar and
then click the Calculation tab on the Options dialog box... look at the top section (labeled Calculation)... is Automatic checked? Rick "Mumsy" (donotspam) wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
