I have two sheets in the same workbook. One has "Data" and the other is a "Summary".
For the sake of simplicity, lets assume the "Data" sheet looks like this:
<tbody>
</tbody>
I'm trying to get the "Summary" sheet to update with the corresponding summed values for each month, like this:
<tbody>
</tbody>
I started with =INDEX(Data!A1:D11,MATCH('Summary'!A2,Data!A2:A11,0),Match('Summary'!B1,Data!B1:D1,0))
but, of course, this only returns the first value with the matching data rather than summing all of the "matching" entries.
I changed my formula to a =SUM(IF(.... {ARRAY} and I tried a =SUM(INDEX(... formula, but neither are returning the intended result, if any.
I'd really appreciate assistance with this.
TY!!
For the sake of simplicity, lets assume the "Data" sheet looks like this:
A | B | C | D | |
1 | JAN | FEB | MAR | |
2 | Purchase | 100.00 | 150.00 | 225.00 |
3 | Insurance | 500.00 | 500.00 | 500.00 |
4 | Ads | 1,000.00 | 750.00 | 250.00 |
5 | Ads | 1,500.00 | 500.00 | 250.00 |
6 | Supply | 500.00 | 425.00 | 350.00 |
7 | Purchase | 250.00 | 300.00 | 550.00 |
8 | Insurance | 150.00 | 150.00 | 75.00 |
9 | Insurance | 75.00 | 75.00 | 75.00 |
10 | Supply | 150.00 | 250.00 | 300.00 |
11 | Purchase | 125.00 | 225.00 | 250.00 |
<tbody>
</tbody>
I'm trying to get the "Summary" sheet to update with the corresponding summed values for each month, like this:
A | B | C | D | |
1 | JAN | FEB | MAR | |
2 | Ads | 2,500.00 | ||
3 | Insurance | 725.00 | ||
4 | Purchase | 475.00 | ||
5 | Supply | 650.00 |
<tbody>
</tbody>
I started with =INDEX(Data!A1:D11,MATCH('Summary'!A2,Data!A2:A11,0),Match('Summary'!B1,Data!B1:D1,0))
but, of course, this only returns the first value with the matching data rather than summing all of the "matching" entries.
I changed my formula to a =SUM(IF(.... {ARRAY} and I tried a =SUM(INDEX(... formula, but neither are returning the intended result, if any.
I'd really appreciate assistance with this.
TY!!