Hi All,
I have an indirect formula which works fine however I now need to make the SUM range dynamic as its basically summing a different date each week.
<tbody>
</tbody>
This is the formula I currently have
=SUMIFS(INDIRECT($A12&"!H:H"),INDIRECT($A12&"!$A:$A"),$B12,INDIRECT($A12&"!$B:$B"),$C12,INDIRECT($A12&"!$F:$F"),$G12)
Column H in this case is where all of the october 6th is but next week I want the SUM range to be on column I which is October 13th. Obviously I want this to happen without changing it every week. I have made a list table which has all dates in there so I presume I need to link it to this somehow? My question is how do I do that?
thanks in advance
I have an indirect formula which works fine however I now need to make the SUM range dynamic as its basically summing a different date each week.
Name | 06/10/16 (this date changes each week) |
David | 8 (this is where the formula would be) |
<tbody>
</tbody>
This is the formula I currently have
=SUMIFS(INDIRECT($A12&"!H:H"),INDIRECT($A12&"!$A:$A"),$B12,INDIRECT($A12&"!$B:$B"),$C12,INDIRECT($A12&"!$F:$F"),$G12)
Column H in this case is where all of the october 6th is but next week I want the SUM range to be on column I which is October 13th. Obviously I want this to happen without changing it every week. I have made a list table which has all dates in there so I presume I need to link it to this somehow? My question is how do I do that?
thanks in advance