I have the following data and am trying to find the sum based on the following inputs:
1. Start Date (e.g. Jan-17)
2. End Date (e.g. Mar-17)
3. Row Header (A)
What formula can I build that would be dynamic based on my three inputs and output the sum?
<colgroup><col><col span="12"></colgroup><tbody>
</tbody>
Thanks!
1. Start Date (e.g. Jan-17)
2. End Date (e.g. Mar-17)
3. Row Header (A)
What formula can I build that would be dynamic based on my three inputs and output the sum?
Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | |
A | $2,000 | -$780 | -$780 | -$780 | -$780 | -$780 | -$2,000 | -$2,000 | -$2,000 | -$2,000 | -$2,000 | -$2,000 |
B | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 |
C | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 | -$300 |
D | -$50 | -$50 | -$50 | -$50 | -$50 | -$50 | -$50 | -$50 | -$50 | -$50 | -$50 | -$50 |
E | -$20 | -$20 | -$20 | -$20 | -$20 | -$20 | -$20 | -$20 | -$20 | -$20 | -$20 | -$20 |
F | -$117 | -$117 | -$117 | -$117 | -$117 | -$117 | -$117 | -$117 | -$117 | -$117 | -$117 | -$117 |
Total Costs | $1,214 | -$1,567 | -$1,567 | -$1,567 | -$1,567 | -$1,567 | -$2,787 | -$2,787 | -$2,787 | -$2,787 | -$2,787 | -$2,787 |
<colgroup><col><col span="12"></colgroup><tbody>
</tbody>
Thanks!