formula to count unique values based on multiple criteria

WS Attached
I need a formula to count unique values when multiple criteria is present.
B2 is where the formula goes.
D2:D12 is the range to only count unique values, counting only once, however only counting them if E2:E12 text is “SOLD”.
In the worksheet, I highlighted the amount of times the formula should count which is a total of 5 times.

Cell B2 array formula

Formula:

Please Login or Register  to view this content.

its coming back 0, not working. should come back counting 5

It is an array formula, you must confirm it with Ctrl+Shift+Enter.

Or try:

=SUMPRODUCT((E2:E12="SOLD")/COUNTIFS(D2:D12,D2:D12,E2:E12,E2:E12))

just Enter.

oh ok, thanks, it works great!

@excelteam777 You're Welcome. Glad to help . Thank You for the feedback