Hi Mike,

Try this

=SUMPRODUCT((A1:A100="UK")/COUNTIF(B1:B100,B1:B100&"")*(B1:B100<""))

--
HTH

Bob Phillips

"Mike" wrote in message
...
I have a list of names with mutiple entries for most of them
I need to count the unique names but that only meet another criteria

eg
A B
Uk Mike
DE Fred
Uk Mike
Ch Ted
Uk Rose

What I need is a formulae that will let me specify if colulm A is UK count
the unique names in colum B - the answer should be 2 (Mike & Rose are in
UK)

Thanks