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!

=sum(offset(M4,0,0,1,COUNTIF($m$2:$z$2,"<"&today() ))

if the dates are in row 2 as DATES, the COUNTIF() will figure out how many
columns to include. The SUM() and OFFSET() ought to deal with everything

"Karen D" wrote:

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!

Thank you thank you!!! I've been at this all day! :)

"Duke Carey" wrote:

=sum(offset(M4,0,0,1,COUNTIF($m$2:$z$2,"<"&today() ))

if the dates are in row 2 as DATES, the COUNTIF() will figure out how many
columns to include. The SUM() and OFFSET() ought to deal with everything

"Karen D" wrote:

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!