Dragging Series?

[Guidu]

look at cells A3 A4 and A5, I would like to drag and continuing the
serie...jumping two cells while dragging. or like cells D3, E3 and F3
(esentially the same)


A B C D E F

1 2 1 8 2 6 8
2
3 3 (A1+B1) 3 10 14
4 10 (C1+D1) (A1+B1) (C1+D1) (E1+F1)
5 14 (E1+F1)
6

 

[bpeltzer]

=sum(offset($A$1,0,2*row()-6,1,2))

 

[Ken Johnson]

look at cells A3 A4 and A5, I would like to drag and continuing the
serie...jumping two cells while dragging. or like cells D3, E3 and F3
(esentially the same)

        A       B       C       D       E       F

1       2       1       8       2       6       8
2                                              
3       3       (A1+B1)         3       10      14
4       10      (C1+D1)         (A1+B1) (C1+D1) (E1+F1)
5       14      (E1+F1)                        
6                                              

Try...

=SUM(OFFSET($A$1:$B$1,0,ROWS($1:1)*2-2))

Ken Johnson

 

[Guidu]

Thank you very much

=sum(offset($A$1,0,2*row()-6,1,2))