Hi Bedros,

Try:

Tools | Options | Calculation | select Automatic

---
Regards,
Norman



"Bedros" wrote in message
...
When I use the formula to total a colum of monatary numbers in a colum as
an
example =sum(e3:e166) I get a total but if I insert another figure in a
blank
space within those limits it doesn't add it in the total.

What am I to do so it automatically adds it to the total?

I really appreciated the answer you gave me to my previous question.

Thanks again