Using Variables in Summing Formulas in Excel/Open Calc

Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
Sign up Log in
3 replies · 3K views
Kuryakin
Messages
10
Reaction score
0
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
 

Discussion

Physics news on Phys.org
Hi, ok you need to use a function called "INDIRECT()".

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

Note: & is the concatenation operator, not +.
 
SUM(A1:A(1+F4)) this formula i don't think is correct.
simply use with + sign