View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default 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