SUMIF with Index Match with multiple criteria

[a777kz]

Hello.

I have the following table (assume there is data), but the format is like below:


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]June[/TD]
[TD][/TD]
[TD][/TD]
[TD]July[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]Actual[/TD]
[TD]Budget[/TD]
[TD]Variance[/TD]
[TD]Actual[/TD]
[TD]Budget[/TD]
[TD]Variance[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Product 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Product 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Product 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Product 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Product 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Product 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

On a separate tab I need to sum and lookup for all Product 1 data based on a few criteria: Month and Actual or Budget. Also note that month is merged across three cells (for instance June is merged and centered (B1:D1). So on a separate tab if I choose July and Actual, I will need to see all the sums by Product 1, 2, 3 etc.

I believe I need to use sumifs(index(match) formula, but it doesnt seem to work.

Thanks for help.

 

[a777kz]

anyone can help with this?