=SUMPRODUCT(--(emp_num_cell=Sheet2!emp_num_range),--(adm_date_cell<=Sheet2!adm_date_range),Sheet2!hour s_range)

--
__________________________________
HTH

Bob

"Marco" wrote in message
...
Hello. I already search some post about this but I didn't understood.

I have a sheet with 3 columns: EmployeeNumber; Name; AdmissionDate

In another sheet I have another 3 columns: EmployeeNumber; NumberOfHours;
Date

I need to sum in sheet one all hours that are in sheet two, but I need
something like: Sum if EmployeeNumber=EmployeeNumber and Date
=AdmissionDate

So, in resume I need to sum all hours from an employee that are equal or
bigger is AdmissionDate

I have Excel 2003 and 2007, so ......

Please Help.

Regards,
Marco