marieemery
New Member
- Joined
- Aug 3, 2011
- Messages
- 5
Please can you help with creating a formula for the following?
My colleage has sent me a file with COUNTIFS however this function doesn't appear to work in excel 2003 and I understand that I may need to use SUMPRODUCT?
I have 2 spreadsheets in a workbook that list employee names, employee numbers:
1. Spreadsheet has employee name, number, absence code and absence in hours/days (only for employees with absence in the last month)
2. Spreadsheet has all employee details including name, number etc
I am trying to create a formula that will pull the absence data from sheet and input this into sheet 2. It would need to pick up both the employee number, absence code
Hope this makes sense
My colleage has sent me a file with COUNTIFS however this function doesn't appear to work in excel 2003 and I understand that I may need to use SUMPRODUCT?
I have 2 spreadsheets in a workbook that list employee names, employee numbers:
1. Spreadsheet has employee name, number, absence code and absence in hours/days (only for employees with absence in the last month)
2. Spreadsheet has all employee details including name, number etc
I am trying to create a formula that will pull the absence data from sheet and input this into sheet 2. It would need to pick up both the employee number, absence code
Hope this makes sense
