=SUMPRODUCT((A2:A1000="City Name")*(B2:B1000 = "Employee Status")*(C2:C1000))

HTH,
Bernie
MS Excel MVP


"poor me" <poor wrote in message
...
I have a four-column table. Column A contains City. Columns B through D
contain Employee Status (Contractor/Full time/Part time). The data in the
grid contains the corresponding hourly rates. How can I construct a formula
that will find a person's hourly rate based on their City and Employee Status?