This is the string that produces a working formula.
=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$B15,",Table_Data[",C$26,"])")
C26 - is the header of the table
B15 - is the number of days current or before
<tbody>
</tbody><colgroup><col></colgroup>
=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$B15,",Table_Data[",C$26,"])")
C26 - is the header of the table
B15 - is the number of days current or before
The result is a formula that I can paste into notepad, then re-copy into excel for the correct result. =SUMIF(Table_Data[Date],TODAY()-0,Table_Data[Column1]) The problem is that I need to run the product of the concatenation in about 1000 cells... I've tried using INDIRECT as my tool but I keep getting #REF! as a result instead of the result from the SUMIF... Below is my INDIRECT =INDIRECT(CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$B15,",Table_Data[",C$26,"])")) |
<tbody>
</tbody><colgroup><col></colgroup>