Alternative to SUMPRODUCT?

[roanscar]

Is there a formula that I could use instead of SUMPRODUCT? Each person will only have one entry for per day.

Book1
	A	B	C	D	E	F	G
1	Date	Employee	Amount			10/1	10/2
2	10/2	Bob	25		Bob	45	25
3	10/1	Joe	30		Joe	30	9
4	10/1	Bob	45		Frank	5	35
5	10/1	Katie	15		Katie	15	15
6	10/2	Frank	35
7	10/1	Frank	5
8	10/2	Joe	9
9	10/2	Katie	15
Sheet1

[/img][/code]

 

[BruceyBonu$]

In cell F2

=INDEX($a$2:$c$9,MATCH($e2&"@"&f$1,$b$2:$b$9&"@"&$a$4:$a$10,0),3)
Enter with Ctrl Shift and Enter