A | B | C | D | E | F | G | H | I | J | |
1 | SIZE | ITEM | APR-14 | MAY-14 | JUN-14 | SIZE | ITEM | PERIOD | AMOUNT | |
2 | 0.200 | SCOTCH | 1 | 20 | 3 | 0.200 | SCOTCH | MAY-14 | 20 | |
3 | 0.375 | RUM | 4 | 5 | 6 | |||||
4 | 0.375 | VODKA | 7 | 8 | 9 | |||||
5 | 0.250 | SCOTCH | 10 | 11 | 12 |
<tbody>
</tbody>
<tbody>
</tbody>
Good day all. I'm looking for a formula to sum information based on more than one criteria (in this case, size, item and period) over columns and rows before and including a specific period. Say, the amount of 0.200 Scotch until the end of May 2014, which is 21. |
<tbody>
</tbody>
Code:
[TABLE="width: 793"]
<tbody>[TR]
[TD]=SUMIFS(INDEX($C$2:$E$5,0,MATCH(I2,$C$1:$E$1,0)),$A$2:$A$5,G2,$B$2:$B$5,H2)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any assistance would be greatly appreciated!