Try this ARRAY FORMULA, committed with CTRL+SHIFT+ENTER, instead of just
ENTER:

=SUMPRODUCT(--(FREQUENCY(IF((Month_of_Occurence=$B$2)*
(Month_of_Occurence<=$B$3)*(Branch=$B$10),MATCH(Em pcode,Empcode,0)),
ROW(Empcode)-MIN(ROW(Empcode)))0))

That formula assumes there is a 3rd range named EmpCode.

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Max" wrote in message
...
Looking for a way to enhance this sumproduct expression
to return a unique employee code count:

=SUMPRODUCT((Month_of_Occurence=$B$2)*(Month_of_O ccurence<=$B$3)*(Branch=$B10))

Suppose the expression above returns: 5

In a corresponding named range: EmpCode
(range not used in the expression as yet)
the 5 instances returned are due to eg:

Emp1
Emp2
Emp1
Emp3
Emp2

Would like to return a unique employee code count of: 3
for the 5 instances. Thanks.