[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A1,",Table_Data[",A$20,"])")[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A1,",Table_Data[",B$20,"])")[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A1,",Table_Data[",C$20,"])")[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A2,",Table_Data[",A$20,"])")[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A2,",Table_Data[",B$20,"])")[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A2,",Table_Data[",C$20,"])")[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A3,",Table_Data[",A$20,"])")[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A3,",Table_Data[",B$20,"])")[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A3,",Table_Data[",C$20,"])")[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A4,",Table_Data[",A$20,"])")[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A4,",Table_Data[",B$20,"])")[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A4,",Table_Data[",C$20,"])")[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A5,",Table_Data[",A$20,"])")[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A5,",Table_Data[",B$20,"])")[/TD]
[TD]=CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$A5,",Table_Data[",C$20,"])")[/TD]
[/TR]
</tbody>[/TABLE]
This is where I Pasted the values, then highlighted all the new values and repeatedly pressed 'F2' then 'Enter'
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-0,Table_Data[Stuff_1])[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-0,Table_Data[Stuff_2])[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-0,Table_Data[Stuff_3])[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-1,Table_Data[Stuff_1])[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-1,Table_Data[Stuff_2])[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-1,Table_Data[Stuff_3])[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-2,Table_Data[Stuff_1])[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-2,Table_Data[Stuff_2])[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-2,Table_Data[Stuff_3])[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-3,Table_Data[Stuff_1])[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-3,Table_Data[Stuff_2])[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-3,Table_Data[Stuff_3])[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-4,Table_Data[Stuff_1])[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-4,Table_Data[Stuff_2])[/TD]
[TD]=SUMIF(Table_Data[Date],TODAY()-4,Table_Data[Stuff_3])[/TD]
[TD]...[/TD]
[/TR]
</tbody>[/TABLE]
Table_Data
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]Stuff_1[/TD]
[TD]Stuff_2[/TD]
[TD]Stuff_3[/TD]
[TD]Stuff_4[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]06/22/2007[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]06/22/2007[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD]06/20/2007[/TD]
[/TR]
</tbody>[/TABLE]