Sum of Columns
 

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

Sum of Columns
 

More info and examples


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

Sum of Columns
 

I'm not sure what you have in mind, but I guess this is it:

=SUM(INDIRECT(LEFT(ADDRESS(1,Z_1,4),1)&":"&LEFT(AD DRESS(1,Z_2,4),1)))

If this is not the case, please, provide more information.

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/

Sum of Columns
 

=SUM(INDIRECT(CHAR(Z1+64)&ROW()):INDIRECT(CHAR(Z2+ 64)&ROW()))

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Ekans" escreveu:

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

Sum of Columns
 

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