Sum of Columns

[Ekans]

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

 

[Don Guillett]

More info and examples

 

[Robert Martim, Excel]

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(ADDRESS(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/

 

[Marcelo]

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

hth

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



"Ekans" escreveu:

 

[RagDyer]

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.