Unique Count within a Sumproduct Formula

[davidhall80]

The formula below is how I come up with 5500 employee transactions. It gives me 5500 out of about 7500. Of this 5500, I need to get a unique count of Employee ID's so I can get an accurate headcount. I need a way to stick a formula at the end of this formula to give me a unique count of the 5500 list. The Employee ID's are on the same "New Ending 09-24-06" tab in column B as the other information that I'm pulling from. Is this possible?


SUMPRODUCT(--('New Ending 09-24-06 WO AV'!$Y$2:$Y$7594>0),--('New Ending 09-24-06 WO AV'!$Z$2:$Z$7594>0),--('New Ending 09-24-06 WO AV'!AE2:AE7594>0))
_________________