Add in excel

[G2K]

Hi all,

i think it would be stupid to ask this question here but i am really not able to get this simple formula

lets a1,a2,a3,a4,a5,a6 and a7 cells have value 10,12,14,16,18,20,22
and b1,c1,d1,e1,f1,g1, and hi cells have value 2,4,6,8,10,12,14 respectivley

i want to add a1 and b1,a2 and c1 ..........a7 and h1 in a20,a21.....

can anybody help me to get the formula............

 

[sanrv1f]

try

A20

=A1+OFFSET($A$1,,ROWS(A$20:A20))

and copied down

 

[G2K]

Bingo.........

Thanks a ton sir......................