=COUNT(1/IF((Month_of_Occurence=$B$2)*(Month_of_Occurence< =$B$3),MATCH(Employees,Employees,0)=ROW(Employees)-MIN(ROW(Employees))+1))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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.