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