Count with multiple criteria and exclude duplicates

[nasee95]

I want to count the data in column D by excluding duplicate value with multiple criteria.
For example, I would like to count data excluding duplicate in column D with criteria of the column B=M2X-1, and column L=crack.
If I manually remove the duplicate, the result of count should be 2.
Since I am working on series of data and this is only small part of it which consume my time to filter out manually.
Hope you guys can help me with this.

Thank you in advance

Wire Summary 2022.xlsx
	B		D								L
27	AGNI-10		2121977/2-001A								Dented on shank
28	AGNI-10		2122052/3-001A								Dented on shank
29	NEOTACT-ZX		2121708/2-001A								Crack
30	M2X-1		2121050/1-001A								Crack
31	M2X-1		2121049/1-001A								Crack
32	M2X-1		2121050/1-001A								Crack
33	M2X-1		2121050/1-001A								Crack
34	M2X-1		2121049/1-001A								Crack
35	M2X-1		2121692/1-001A								Crack
Jan 21

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:D63,K:K,C89:D1048576,C86:C88,C65:D85,C64	Cell Value	duplicates	text	NO

 

[Fluff]

You're welcome & thanks for the feedback.