Try this:

With your data list in A1:C4

E1: 9836
F1: 09/16/2006

This formula returns the total hours logged by 9836 on 09/16/2006
G1: =SUMPRODUCT(($B$1:$B$10=E1)*($A$1:$A$10=F1)*$C$1:$ C$10)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Kelly" wrote:

I have a worksheet that has a lot of information in it. I am trying to find a
formula that will look up logged hours based on 2 criteria. First i am
looking for a specific agent that has an ID.(9876) Then i want to find a
specific date (9/16/2006). I then want it to return the logged hours for that
agent on that date.

Ex

A B C
1 9/15/2006 9836 15
2 9/16/2006 5321 16.2
3 9/16/2006 9836 12.5
4 9/17/2006 4825 13.5


I want it to give me that agent 9836 was logged in for 12.5 hours.