JakeTheSnake3.0
Board Regular
- Joined
- Jan 29, 2009
- Messages
- 86
Hello,
Sorry this might take a bit to explain, but here goes:
I have a workbook that keeps track of employee payments. Each pay period is accounted for on each subsequent line starting from 6. What I need to do is to figure out how many unique employees were working for a given month (which includes multiple pay periods).
I count the employees by checking the "paid" column for a given pay period. If there's something in there, that means they worked for that given pay period.
Here is the formula I have so far:
M6 is pay period 1...M7 is pay period 2...Both pay period 1 and 2 fall under "January"; so what I need to do, is find out IF the employee worked in January at all. The problem with this formula, is that it counts BOTH M6 and M7. So that pretty much eliminates uniqueness.
Any thoughts?
Sorry this might take a bit to explain, but here goes:
I have a workbook that keeps track of employee payments. Each pay period is accounted for on each subsequent line starting from 6. What I need to do is to figure out how many unique employees were working for a given month (which includes multiple pay periods).
I count the employees by checking the "paid" column for a given pay period. If there's something in there, that means they worked for that given pay period.
Here is the formula I have so far:
Code:
=COUNTA('Employee1:Employee20'!M6:M7)
M6 is pay period 1...M7 is pay period 2...Both pay period 1 and 2 fall under "January"; so what I need to do, is find out IF the employee worked in January at all. The problem with this formula, is that it counts BOTH M6 and M7. So that pretty much eliminates uniqueness.
Any thoughts?