View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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