Hi George,
Perhaps this formula will do the trick..
Here the A19:A225 are the titles within which you are looking for the unique
values

=SUMPRODUCT(--(A19:A225="T1"),--((FREQUENCY(MATCH($A$19:$A$224 &
B$19:$B$224,$A$19:$A$224 & $B$19:$B$224,0),MATCH($A$19:$A$224 &
$B$19:$B$224,$A$19:$A$224 & $B$19:$B$224,0))0)))

Alok

"George Lynch" wrote:

I need to count unique names in a list, but only when the unique name meets a
condition (a specific title, for example) in another column. So let's say I
have my list of names (many repeats) in B19:B224, and my list of titles in
D19:D224. What I need to do is to count the unique names in the A column
where the title is "Director", or "Vice President", etc.

I can count the unique names in the A column with this formula:

=SUM(IF(FREQUENCY(MATCH($B$19:$B$224,$B$19:$B$224, 0),MATCH($B$19:$B$224,$B$19:$B$224,0))0,1))

I have thus far been unable to figure out a formula that will allow me to
count the unique names in the B column based on specific titles in the D
column.

Thanks in advance for any and all help...

George