Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |