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" wrote in message
...
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" wrote in
message
...
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" wrote in
message
...
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" wrote in message
...
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" wrote in
message
...
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" wrote in
message
...
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" wrote in
message
...
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


.



.