Please see the two tables below. So I have one sheet called DATA SHEET and another called INPUT SHEET. Now, I want to calculate the difference between INVOICED and ACCRUED for each month for each product for their specific advertising type. And would like to have the difference shown up in INPUT SHEET. (ex. in the Input sheet, C3 would be -500; 1500-2000).
I have been just manually doing SUMIFS using product and adv type. But is there a way I can add the month to the formula, so that all I have to do is input the data for future months and the formula would pick it up in the input sheet??
Thank you!!!
DATA SHEET #1
<thead>
</thead><tbody>
</tbody>
INPUT SHEET #2
<thead>
</thead><tbody>
</tbody>
I have been just manually doing SUMIFS using product and adv type. But is there a way I can add the month to the formula, so that all I have to do is input the data for future months and the formula would pick it up in the input sheet??
Thank you!!!
DATA SHEET #1
A | B | C | D | E | F | G | H | |||
---|---|---|---|---|---|---|---|---|---|---|
ACCRUED | INVOICED | ACCRUED | INVOICED | ACCRUED | INVOICED | |||||
PRODUCT | ADV. TYPE | JAN-17 | JAN-17 | FEB-17 | FEB-17 | MAR-17 | MAR-17 | |||
GUM | TV | 2000 | 1500 | 1000 | 1000 | 1500 | 2000 | |||
GUM | RADIO | 1500 | 1300 | 1300 | 1315 | 1450 | 1400 | |||
ICE CREAM | TV | 2000 | 2300 | 2500 | 2600 | 2500 | 2300 | |||
ICE CREAM | RADIO | 1200 | 1250 | 1200 | 1150 | 1100 | 1000 | |||
<thead>
</thead><tbody>
</tbody>
INPUT SHEET #2
A | B | C | D | E | ||||||
---|---|---|---|---|---|---|---|---|---|---|
PRODUCT | ADV. TYPE | JAN-17 | FEB-17 | MAR-17 | ||||||
GUM | TV | |||||||||
GUM | RADIO | |||||||||
ICE CREAM | TV | |||||||||
ICE CREAM | RADIO | |||||||||
<thead>
</thead><tbody>
</tbody>