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?