summing cells with variables

J

jeff

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
 
B

Bob Phillips

Something like

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

--

HTH

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

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
 
J

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
 
B

Bob Phillips

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)
 
G

Guest

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

thank you!
Jeff
 
Top