Hi, I'm trying to come up with a dynamic suming range within sumifs formula.
I'm trying to sum between today and today +12 with several conditions.
How can I get to the below result with a SUMIFS? What I'm struggling with is to come up with a dynamic summing range. Most probably with OFFSET?
Sheet1
Assuming the data starts in A1
<tbody>
</tbody>
The expected result is the sum between Dec-18 and Nov-19 = 140
Sheet2
Assuming the date starts in A1
<tbody>
</tbody>
I'm trying to sum between today and today +12 with several conditions.
How can I get to the below result with a SUMIFS? What I'm struggling with is to come up with a dynamic summing range. Most probably with OFFSET?
Sheet1
Assuming the data starts in A1
Model | Region | Calculation |
Model 1 | Region 1 | (expected result 140 from sheet 2) |
<tbody>
</tbody>
The expected result is the sum between Dec-18 and Nov-19 = 140
Sheet2
Assuming the date starts in A1
Model | Region | Dec-18 | Jan-19 | Feb-19 | Mar-19 | Apr-19 | May-19 | Jun-19 | Jul-19 | Aug-19 | Sept-19 | Oct-19 | Nov-19 | Dec-19 |
Model 1 | Region 1 | 5 | 3 | 4 | 6 | 9 | 16 | 15 | 20 | 23 | 22 | 9 | 8 | 1 |
<tbody>
</tbody>