Dragging Series?
 

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

Dragging Series?
 

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

"Guidu" wrote:

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

Dragging Series?
 

On Oct 4, 7:11*am, Guidu wrote:

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

Dragging Series?
 

Thank you very much

"bpeltzer" wrote:

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

"Guidu" wrote:

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