Using Variables in Summing Formulas in Excel/Open Calc

[Kuryakin]

In excel, using Open Calc but I assume they're the same.

Is their a way to put variables value into summing formulas. I wanted to sum from A1 to an A cell which is numbered A1+F4. So if F4 = 100 I'd want to SUM(A1:A101)
I tried SUM(A1:A(1+F4)) but it gives a number error

 

[JaredJames]

Hi, ok you need to use a function called "INDIRECT()".

Example: =SUM(INDIRECT("A1:A"&F4))

Note: & is the concatenation operator, not +.

 

[Kuryakin]

Thank-you.

 

[JhonMoney]

SUM(A1:A(1+F4)) this formula i don't think is correct.
simply use with + sign