How do I Find/Sum values based on 2 critera?

Hi I have the following table,

Names:
A1: Jon Doe
A2: Jane Doe
A3: Tim Doe
A5: Tim Tom
A6: Jon Tool
A7: Jon Doe

Month:
B1: Jan 2009
B2: Feb 2009
B3: Mar 2009
B4: Apr 2009
B5: Feb 2009
B6: Jan 2009
B7: Feb 2009

Hours Worked:
C1: 5
C2: 4
C3: 3
C4: 1
C5: 2
C6: 3
C7: 8

Position:
D1: Manager
D2: Temp
D3: Temp
D5: Temp
D6: Full-Time
D7: Manager


I want to create 2 tables.
#1) That will give me the employee name, and the total number of hours they've worked in a specified time period
#2) That will summarize the table, and filter out unecessary data, and tell me how many hours an employee worked each month. With the x axis being the employee, and the y axis being the month.

So I have the following:

Table #1
Name:
A1: Jon Doe
A2: Jane Doe
A3: Tim Doe
A5: Tim Tom
A6: Jon Tool

Hours Worked in From Jan-Feb 2009:
B1: 13 (5+8)
B2: 4
B3: 3
B4: 1
B5: 2
B6: 3

And the following table:

Table #2
Name:
A2: Jon Doe
A3: Jane Doe
A4: Tim Doe
A5: Tim Tom
A6: Jon Tool

B1: Jan 2009
B2: 5
B3: 0
B4: 0
B5: 3
B6: 0

C1: Feb 2009
C2: 8
C3: 4
C4: 0
C5: 0
C6: 0

C1: Mar 2009
C2: 0
C3: 0
C4: 3
C5: 0
C6: 0

...and so on

Can you tell me how i can do this? Any help would be greatly appreciated.

Look at the attached example.
If you have questions, post it.
hope it helps.
modytrane

=SUMPRODUCT(--(A1:A5=F1),--(B1:B5=G1),C1:C5)

the above formula is returning a value 0 for me. my table shows like

XEN1 ABC BAN
XEN2 YXH JAN
XEN3 XXH TAN
XHB4 YXH PRN
XHB5 YXH VCB

values in my F1 and G1 are F1 = XEN1 G1 = ABC And I have typed the above formula in H1. I expect BAN to be returned in H1, but is getting 0 only.

Thanks for your help

try

=INDEX($C$1:$C$5,MATCH(1,($A$1:$A$51=F1)*($B$1:$B$51=G1),0))
confirmed with ctrl+shift+enter so it changes to array formula
{=INDEX($C$1:$C$5,MATCH(1,($A$1:$A$51=F1)*($B$1:$B$51=G1),0))}