Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why won't colums add if new infor mation is added?
In my worksheet i have colums with a total on the botom. After using the
autosum it will add what is already inputed but won't update if you enter another number.....? 1 200 1 200 2 100 2 100 3 3 500 4 200 4 200 Total 500 Total 500 Colum will not update....? I've tried error checking and still nothing ......Help? |
#2
|
|||
|
|||
Check the formula for the Total.
Chek that calculation is set to Automatic. Something I've seen done is to autosum the list, but also a blank line following the list. Users can highlight the blank row, select insert, then enter their own information in the newly inserted row. Totals continue to work. -- Rob van Gelder - http://www.vangelder.co.nz/excel "Mike" wrote in message ... In my worksheet i have colums with a total on the botom. After using the autosum it will add what is already inputed but won't update if you enter another number.....? 1 200 1 200 2 100 2 100 3 3 500 4 200 4 200 Total 500 Total 500 Colum will not update....? I've tried error checking and still nothing .....Help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reference the last 3 cells in a row as cells are added | Excel Worksheet Functions | |||
How do I keep a formula from changing if a row is added or deleted | Excel Discussion (Misc queries) | |||
How do I keep a formula from changing if a row is added or delete. | Excel Discussion (Misc queries) | |||
switch colums and rows | New Users to Excel | |||
How to add up a number of colums (posted on 29/10/04) | Excel Worksheet Functions |