summing cells with variables

I need to sum a group of cells, but the column is
dependent on another equation. Therefore I know that I
want to sum from G1 and I know that I want to sum to the
13th row and kth column where k is a number that has been
calculated using the MATCH function.

Any help would be greatly appreciated.

Jeff

Something like

=SUM(OFFSET(A13,,,MATCH("t",H1:H25,0)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jeff" <[email protected]> wrote in message
news:[email protected]...
> I need to sum a group of cells, but the column is
> dependent on another equation. Therefore I know that I
> want to sum from G1 and I know that I want to sum to the
> 13th row and kth column where k is a number that has been
> calculated using the MATCH function.
>
> Any help would be greatly appreciated.
>
> Jeff

Bob,

thank you for the quick reply. This is almost exactly
it. The one difference is that this sums one row only, I
would like to sum across several ros (e.g. a-f). Any
ideas?

Jeff
>-----Original Message-----
>Something like
>
>=SUM(OFFSET(A13,,,MATCH("t",H1:H25,0)))
>
>--
>
>HTH
>
>RP
>(remove nothere from the email address if mailing direct)
>
>
>"jeff" <[email protected]> wrote in
message
>news:[email protected]...
>> I need to sum a group of cells, but the column is
>> dependent on another equation. Therefore I know that I
>> want to sum from G1 and I know that I want to sum to
the
>> 13th row and kth column where k is a number that has
been
>> calculated using the MATCH function.
>>
>> Any help would be greatly appreciated.
>>
>> Jeff
>
>
>.
>

Here is my attempt at this

=SUM('Resource Plan'!G4:OFFSET('Resource Plan'!G13,,,MATCH
(RatePeriod_1,ProjectTimeLine,1)))

where MATCH(RatePeriod_1,ProjectTimeLine,1)=17

but I end up with a value of 0. It should be 30.

Jeff




>-----Original Message-----
>Something like
>
>=SUM(OFFSET(A13,,,MATCH("t",H1:H25,0)))
>
>--
>
>HTH
>
>RP
>(remove nothere from the email address if mailing direct)
>
>
>"jeff" <[email protected]> wrote in
message
>news:[email protected]...
>> I need to sum a group of cells, but the column is
>> dependent on another equation. Therefore I know that I
>> want to sum from G1 and I know that I want to sum to
the
>> 13th row and kth column where k is a number that has
been
>> calculated using the MATCH function.
>>
>> Any help would be greatly appreciated.
>>
>> Jeff
>
>
>.
>

Jeff,

I assume you mean columns, not rows? Try this then

=SUM(OFFSET(A13,,,MATCH("t",H1:H25,0),6))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"jeff" <[email protected]> wrote in message
news:[email protected]...
> Bob,
>
> thank you for the quick reply. This is almost exactly
> it. The one difference is that this sums one row only, I
> would like to sum across several ros (e.g. a-f). Any
> ideas?
>
> Jeff
> >-----Original Message-----
> >Something like
> >
> >=SUM(OFFSET(A13,,,MATCH("t",H1:H25,0)))
> >
> >--
> >
> >HTH
> >
> >RP
> >(remove nothere from the email address if mailing direct)
> >
> >
> >"jeff" <[email protected]> wrote in
> message
> >news:[email protected]...
> >> I need to sum a group of cells, but the column is
> >> dependent on another equation. Therefore I know that I
> >> want to sum from G1 and I know that I want to sum to
> the
> >> 13th row and kth column where k is a number that has
> been
> >> calculated using the MATCH function.
> >>
> >> Any help would be greatly appreciated.
> >>
> >> Jeff
> >
> >
> >.
> >

Just needed to swap the match function and the the 6 to
do what I needed.

thank you!
Jeff
>-----Original Message-----
>Jeff,
>
>I assume you mean columns, not rows? Try this then
>
>=SUM(OFFSET(A13,,,MATCH("t",H1:H25,0),6))
>
>
>--
>
>HTH
>
>RP
>(remove nothere from the email address if mailing direct)
>
>
>"jeff" <[email protected]> wrote in
message
>news:[email protected]...
>> Bob,
>>
>> thank you for the quick reply. This is almost exactly
>> it. The one difference is that this sums one row
only, I
>> would like to sum across several ros (e.g. a-f). Any
>> ideas?
>>
>> Jeff
>> >-----Original Message-----
>> >Something like
>> >
>> >=SUM(OFFSET(A13,,,MATCH("t",H1:H25,0)))
>> >
>> >--
>> >
>> >HTH
>> >
>> >RP
>> >(remove nothere from the email address if mailing
direct)
>> >
>> >
>> >"jeff" <[email protected]> wrote in
>> message
>> >news:[email protected]...
>> >> I need to sum a group of cells, but the column is
>> >> dependent on another equation. Therefore I know
that I
>> >> want to sum from G1 and I know that I want to sum to
>> the
>> >> 13th row and kth column where k is a number that has
>> been
>> >> calculated using the MATCH function.
>> >>
>> >> Any help would be greatly appreciated.
>> >>
>> >> Jeff
>> >
>> >
>> >.
>> >
>
>
>.
>