SUM IF with multiple column and row criteria

[KATMUC]

---

	Jan	Jan	Feb	Mar	Mar	Mar
Tax	2	2	2	7
Rent	1	1	1	7
Marketing	3	3	2	7
OPEX	5	5	1	7

<tbody>
</tbody>

	Jan	Feb	Mar
Tax
Rent
Marketing
OPEX

<tbody>
</tbody>

Hi, I was trying to summarise the various columns (I tagged several calendar weeks to Jan in a separate sheet), however
[FONT=Calibri, sans-serif]the formula =SUMIF($B$1:$F$5;J$2;INDEX($B$2:$F$5;0;MATCH($I3;$A$2:$A$5;0))) worked only for the first row (tax), and not for the remaining rows)[/FONT]

 

[AlanY]

try this

Excel 2012
	A	B	C	D	E	F	G
1		Jan	Jan	Feb	Mar	Mar	Mar
2	Tax	2	2	2	7
3	Rent	1	1	1	7
4	Marketing	3	3	2	7
5	OPEX	5	5	1	7
6
7
8		Jan	Feb	Mar
9	Tax	4	2	7
10	Rent	2	1	7
11	Marketing	6	2	7
12	OPEX	10	1	7
Sheet4

Cell Formulas
Range	Formula
B9	=SUMIFS(INDEX($B$1:$G$5,MATCH($A9,$A$1:$A$5,0),0),INDEX($B$1:$G$5,1,0),B$8)

 

[MARZIOTULLIO]

	A​	B​	C​	D​	E​	F​	G​
1​		Jan	Jan	Feb	Mar	Mar	Mar
2​	Tax	2​	2​	2​	7​
3​	Rent	1​	1​	1​	7​
4​	Marketing	3​	3​	2​	7​
5​	OPEX	5​	5​	1​	7​
6​
7​
8​		Jan	Feb	Mar
9​	Tax	4​	2​	7​
10​	Rent	2​	1​	7​
11​	Marketing	6​	2​	7​
12​	OPEX	10​	1​	7​

<tbody>
</tbody>

b9=SUMPRODUCT(($A$2:$A$5=$A9)*($B$1:$G$1=B$8)*($B$2:$G$5)) copy across and down