excel summing

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

Similar Threads for: excel summing
Thread	Forum	Replies
summing noise	Electrical Engineering	8
Summing mixer	Electrical Engineering	1
Difference and summing OP AMP	Engineering, Comp Sci, & Technology Homework	12
summing up torques	Classical Physics	15
summing up some forces	Introductory Physics Homework	2

Kuryakin	excel summing Tweet 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 Blog Entries: 8 Recognitions: Gold Member	Hi, ok you need to use a function called "INDIRECT()". Example: =SUM(INDIRECT("A1:A"&F4)) Note: & is the concatenation operator, not +.

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