hi

if your formula is in A9:

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

-via135



Abhishek kedia Wrote:
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
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=541770