If you are going on a row by row basis, starting in Row3, try this:

=SUM(INDEX(3:3,$Z$1):INDEX(3:3,$Z$2))

And copy down as needed.


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ekans" wrote in message
...
i have to variables,
Z1 = 1
Z2 = 4

that variables can change

that variables are to tell me wich numbers of columns i have to sum
so with that values i have to SUM from column A to column D

can any tell me the formula, i have to type ?

thks