Variables

Question

Trying to find a solution to Sum(x1:xa) where a is a variable number 1-12&nbsp;

sergeibaklan · Answer

soffi1363&nbsp;
Depends on concrete case, as variant
=SUM(X1:INDEX(X:X,a))

soffi1363 · Answer

Hi SergeiThank you for answer. Could not make this work. Maybe Ithis would clarify my problem better. I am trying to sum a column a1 to aX where my X could be a2, a3... i.e.X is 2,3,4.... i.e. a variable. Nested funtions would be to cumbersome to use. Searcing for a better solution.

hansvogelaar · Answer

soffi1363&nbsp;
An alternative:
Let's say you enter a value in cell D1
=SUM(INDIRECT("A1:A"&amp;D1))
&nbsp;
(I don't think it's possible to do what you want without nesting a function within SUM)

soffi1363 · Answer

Hi HansI am afraid you are right

sergeibaklan · Answer

soffi1363&nbsp;
Another variant of&nbsp;HansVogelaar&nbsp;formula
=SUM(A1:INDEX(A:A,D1) )

Forum Discussion

Variables

Share

Resources