Hello,
I have been reviewing previous questions and answers and wasn't able to
locate the answer to mine. If someone could please assist me that would be
greatly appreciated. I have provided the problem below. When I insert a row
under a3 the formula is not automatically incorporated. I have tried the
data--list option and tools-- options. How can i solve this problem so
when a row is inserted at the bottom of the formula range the formula in say
"A1" will autmotically extend

the problem:
A
1 SUM(a2:a3)
2 1
3 2
4sum(A5:A7)
5 4
6 6
7 8

thanks,
Andy