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" <s.hoitinga@hccnet.nl> schreef in bericht
news:4395c9ec$0$817$3a628fcd@textreader.nntp.hccnet.nl...
> 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
>
>

[sybmathics]

Martijn,

I've tried your suggestion
it did not work.

function indirect() takes only one parameter.

keep going



"Martijn" <murpje1999@hotmail.com> wrote in message
news:OstPlFp%23FHA.2464@TK2MSFTNGP15.phx.gbl...
> Sybolt
> try with the formula
> sum(offset())
> grtx's Martijn
>
> "sybmathics" <s.hoitinga@hccnet.nl> schreef in bericht
> news:4395c9ec$0$817$3a628fcd@textreader.nntp.hccnet.nl...
>> 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
>>
>>
>
>

[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" <s.hoitinga@hccnet.nl> wrote in message
news:4395e008$0$813$3a628fcd@textreader.nntp.hccnet.nl...
> Martijn,
>
> I've tried your suggestion
> it did not work.
>
> function indirect() takes only one parameter.
>
> keep going
>
>
>
> "Martijn" <murpje1999@hotmail.com> wrote in message
> news:OstPlFp%23FHA.2464@TK2MSFTNGP15.phx.gbl...
> > Sybolt
> > try with the formula
> > sum(offset())
> > grtx's Martijn
> >
> > "sybmathics" <s.hoitinga@hccnet.nl> schreef in bericht
> > news:4395c9ec$0$817$3a628fcd@textreader.nntp.hccnet.nl...
> >> 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
> >>
> >>
> >
> >
>
>

[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
"RagDyer" <RagDyer@cutoutmsn.com> wrote in message
news:uYPW4np%23FHA.3308@TK2MSFTNGP11.phx.gbl...
> 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" <s.hoitinga@hccnet.nl> wrote in message
> news:4395e008$0$813$3a628fcd@textreader.nntp.hccnet.nl...
>> Martijn,
>>
>> I've tried your suggestion
>> it did not work.
>>
>> function indirect() takes only one parameter.
>>
>> keep going
>>
>>
>>
>> "Martijn" <murpje1999@hotmail.com> wrote in message
>> news:OstPlFp%23FHA.2464@TK2MSFTNGP15.phx.gbl...
>> > Sybolt
>> > try with the formula
>> > sum(offset())
>> > grtx's Martijn
>> >
>> > "sybmathics" <s.hoitinga@hccnet.nl> schreef in bericht
>> > news:4395c9ec$0$817$3a628fcd@textreader.nntp.hccnet.nl...
>> >> 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
>> >>
>> >>
>> >
>> >
>>
>>
>

[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


--

Regards,

Peo Sjoblom

"sybmathics" <s.hoitinga@hccnet.nl> wrote in message
news:4395e81f$0$810$3a628fcd@textreader.nntp.hccnet.nl...
> 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
> "RagDyer" <RagDyer@cutoutmsn.com> wrote in message
> news:uYPW4np%23FHA.3308@TK2MSFTNGP11.phx.gbl...
> > 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" <s.hoitinga@hccnet.nl> wrote in message
> > news:4395e008$0$813$3a628fcd@textreader.nntp.hccnet.nl...
> >> Martijn,
> >>
> >> I've tried your suggestion
> >> it did not work.
> >>
> >> function indirect() takes only one parameter.
> >>
> >> keep going
> >>
> >>
> >>
> >> "Martijn" <murpje1999@hotmail.com> wrote in message
> >> news:OstPlFp%23FHA.2464@TK2MSFTNGP15.phx.gbl...
> >> > Sybolt
> >> > try with the formula
> >> > sum(offset())
> >> > grtx's Martijn
> >> >
> >> > "sybmathics" <s.hoitinga@hccnet.nl> schreef in bericht
> >> > news:4395c9ec$0$817$3a628fcd@textreader.nntp.hccnet.nl...
> >> >> 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
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
>
>

[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



"RagDyer" <RagDyer@cutoutmsn.com> wrote in message
news:uYPW4np%23FHA.3308@TK2MSFTNGP11.phx.gbl...
> 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" <s.hoitinga@hccnet.nl> wrote in message
> news:4395e008$0$813$3a628fcd@textreader.nntp.hccnet.nl...
>> Martijn,
>>
>> I've tried your suggestion
>> it did not work.
>>
>> function indirect() takes only one parameter.
>>
>> keep going
>>
>>
>>
>> "Martijn" <murpje1999@hotmail.com> wrote in message
>> news:OstPlFp%23FHA.2464@TK2MSFTNGP15.phx.gbl...
>> > Sybolt
>> > try with the formula
>> > sum(offset())
>> > grtx's Martijn
>> >
>> > "sybmathics" <s.hoitinga@hccnet.nl> schreef in bericht
>> > news:4395c9ec$0$817$3a628fcd@textreader.nntp.hccnet.nl...
>> >> 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
>> >>
>> >>
>> >
>> >
>>
>>
>