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]