M
Marco
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
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