Adding Rows To Update A Formula
 

Whoever can help

How do you update a cell sum to include a row you have just added to either
the top of your stack or the bottom.

For example if I have the numbers 5,5,5 in cells A3,A4,A5 respectively and
my sum cell is A7 and I add a row either above A43 or below A5 the forumla
won't recognise to include these? Whereas if I added a row between A3,A4 it
would.

I would have thought this may have needed a VB function?

Thanks you in advance for any replies

Adding Rows To Update A Formula
 

Running a macro would probably require you to overtly run it depending on
exactly what you are doing. If you are going to perform an overt action,
then how about selecting A7 (perhaps now A8) and hitting the Autosum button.

--
Regards,
Tom Ogilvy



"msg" wrote:

Whoever can help

How do you update a cell sum to include a row you have just added to either
the top of your stack or the bottom.

For example if I have the numbers 5,5,5 in cells A3,A4,A5 respectively and
my sum cell is A7 and I add a row either above A43 or below A5 the forumla
won't recognise to include these? Whereas if I added a row between A3,A4 it
would.

I would have thought this may have needed a VB function?

Thanks you in advance for any replies

Adding Rows To Update A Formula
 

=SUM(OFFSET(A1,2,0):OFFSET(A7,-1,0))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"msg" wrote in message
...
Whoever can help

How do you update a cell sum to include a row you have just added to
either
the top of your stack or the bottom.

For example if I have the numbers 5,5,5 in cells A3,A4,A5 respectively and
my sum cell is A7 and I add a row either above A43 or below A5 the forumla
won't recognise to include these? Whereas if I added a row between A3,A4
it
would.

I would have thought this may have needed a VB function?

Thanks you in advance for any replies