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


.



.