updation in farmulae

[Guest]

Dear All

I have one query in excel

it is possible in excel

A B
1 11 =sum(a1:a5)
2 12
3 13
4 14
5 15
6
7
8

if I add some more data in A like

A B
1 11 =sum(a1:a5)
2 12 the farmulae in B shall also get atometically updated to
3 13 =sum(a1:a8)
4 14
5 15
6 16
7 17
8 18


I mean to say that if a farmulae referes to a range and if a data has been
added below that range that farmulae get also updated

hope all of u have got me

thanks

 

[via135]

hi

if your formula is in A9:

=SUM(A1:OFFSET(A9,-1,0))

-via135

 

[RAZA]

why to make it complicated simply estimate upto how long the list i
Column A is going to be and simply use sum function to sum up to tha
range.

REGARDS
RAZ

 

[Guest]

Hi

Thanks for response mr via135

I think u hv not got what i mean to say

I mean to say that if a farmulae refers to particular range say a1:a10 and
furhter more data is being added below a10 suppose in a11:a20 then the
farmulae shall also get updated to a1:a20, without making manual updation in
that

hope now u hv got me
thanks

 

[Bondi]

Hi,

Maybe you can use a named dynamic range. You can see how it works on
this link

http://www.contextures.com/xlNames01.html

Regards,
Bondi

 

[Ardus Petus]

in B1, enter:
=SUM(OFFSET(A1,,,COUNTA(A:A)))

HTH