View Single Post
  #1   Report Post  
Karen D
 
Posts: n/a
Default pulling text into a sum formula

This is relating to my previous post. I have figured out how to return the
column letter of the column I want to SUM through in a separate cell (cell
L4). Now what I am trying to do is write a SUM formula that will sum M4 to
the column that is being returned in cell L4. The amount showing in L4 is
"t", which is correct. Now, is there a way to pull the "t" into a SUM
formula?

=SUM(m4:CELL("contents",L4)4) is what I've tried. Is this close?

What I am trying to do in this case is SUM M4 to T4, with T being a variable
that will change depending on what is returned in cell L4.

Thanks!