Excel Formula Assistance

[Neffy]

Hello,

I been whacking my brain on this little problem for a few days now and about to cry

So i have 2 tables

Table1
[TABLE="width: 300"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Name[/TD]
[TD]Hours[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Joe[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Jack[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Joe[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Bob[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Nancy[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Jack[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

Table2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]March[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jack[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nancy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am stuck for the Jan/Feb/March area
I am trying to Pull the data from Table1 via excel.
Using the formula SumProduct
I want to be able to have it look at the entire table(since this is only a small sample),
So what i basically want it to do is If it follows the pass the condition of the "month" and the "name" then if it will project the Hour data in where "x" is.

Not sure if i was being clear enough. If not, then ask questions.
Help me out <3
Thanks !

 

[shg]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][td="bgcolor:#C0C0C0"]

E​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td]Table1[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td="bgcolor:#F3F3F3"]

Month​

[/td][td="bgcolor:#F3F3F3"]

Name​

[/td][td="bgcolor:#F3F3F3"]

Hours​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]

1​

[/td][td]Joe[/td][td]

3​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

1​

[/td][td]Jack[/td][td]

4​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]

2​

[/td][td]Joe[/td][td]

5​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]

2​

[/td][td]Bob[/td][td]

3​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]

2​

[/td][td]Nancy[/td][td]

6​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td]

3​

[/td][td]Jack[/td][td]

4​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

9​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

10​

[/td][td]Table2[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

11​

[/td][td]Name \ Month[/td][td]

1​

[/td][td]

2​

[/td][td]

3​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

12​

[/td][td]Joe[/td][td="bgcolor:#CCFFCC"]

3​

[/td][td="bgcolor:#CCFFCC"]

5​

[/td][td="bgcolor:#CCFFCC"]

0​

[/td][td="bgcolor:#CCFFCC"]B12: =SUMIFS($C$3:$C$8, $B$3:$B$8, $A12, $A$3:$A$8, B$11)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

13​

[/td][td]Jack[/td][td="bgcolor:#CCFFCC"]

4​

[/td][td="bgcolor:#CCFFCC"]

0​

[/td][td="bgcolor:#CCFFCC"]

4​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

14​

[/td][td]Bob[/td][td="bgcolor:#CCFFCC"]

0​

[/td][td="bgcolor:#CCFFCC"]

3​

[/td][td="bgcolor:#CCFFCC"]

0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

15​

[/td][td]Nancy[/td][td="bgcolor:#CCFFCC"]

0​

[/td][td="bgcolor:#CCFFCC"]

6​

[/td][td="bgcolor:#CCFFCC"]

0​

[/td][td][/td][/tr]
[/table]