"Zygy" wrote in message
...
Hi,

I tried it and it worked only when I included the additional lines in the
Sum but when I added another line after that your suggestion did not work.
So, what did I do wrong?
Incidentally this is on Office 2000.


If you sum (say) A1:A35, but your actual data is A1:A25 and you insert a row
at A26, then the sum should still work.