=SUM(IF(FREQUENCY(IF((A1:A100="directed")*(B1:B100 =60)*(C1:C100=285),MATCH(D1:D100,D1:D100,0),""),IF ((A1:A100="directed")*(B1:B100=60)*(C1:C100=285),M ATCH(D1:D100,D1:D100,0),""))0,1))

(Ctrl + Shift + Enter) in some cell to count for the first 100 records.

HTH
GerryK

"carl" wrote:

I am trying to build an array formula that will count the number of unique
values in Col D subject to the value in ColA="Directed", ColB=60, ColC=285.

Is it possible ?

Thank you in advance.