updation in farmulae

Giganews Newsgroups
Subject: updation in farmulae
Posted by:  Abhishek kedia
Date: Fri, 12 May 2006

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

Replies