getting numbers in cells into formula

[sybmathics]

Hi everybody,

I have the following question:

Imagine that I have numers in column A, range A2:A30.

With a formula I found the row number from which I want to start calculating
and placed in cell C1 (let's say 7).
Another formula in C2 finds the stop value (let's say 20).

Is there a way to totalize values in the range found by the formulas in
C1:C2?

In other words, I'm looking for a formula that totalizes the following:
sum(A&value in C1:A&value in C2), so that excel would interprete this as
sum(A7:A20).

Has anyone tackled this problem before?
I'm very interested.

Any help is mostly valued.

Greets,

Sybolt

 

[Martijn]

Sybolt
try with the formula
sum(offset())
grtx's Martijn

 

[sybmathics]

Martijn,

I've tried your suggestion
it did not work.

function indirect() takes only one parameter.

keep going

 

[RagDyer]

Try this:

=SUM(INDEX(A:A,C1):INDEX(A:A,C2))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[sybmathics]

Rag

tried that one also, didnt work.

maybe if you send a copy of your sheet where it did work, it could help me
out

thanks

Sybolt

 

[Peo Sjoblom]

Maybe you can say what didn't work? It does work no doubt about it, only
error here comes from either you applying it or the data not numerical

 

[sybmathics]

Yes Rag,

I'm sorry for mistaking your suggestion,

I only was confused about the list seperator , or ; .

Your solution did it.!!!

thanks,

Sybolt