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.