updation in farmulae
 

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

updation in farmulae
 

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

updation in farmulae
 

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

REGARDS
RAZA


--
RAZA
------------------------------------------------------------------------
RAZA's Profile: http://www.excelforum.com/member.php...o&userid=34186
View this thread: http://www.excelforum.com/showthread...hreadid=541770

updation in farmulae
 

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

"via135" wrote:


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

updation in farmulae
 

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

updation in farmulae
 

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

HTH
--
AP

"Abhishek kedia" a écrit dans le
message de news: ...
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