Count unique values using Countifs

[PP3321]

Thank you always for your help.

I need to count unique values using countifs (2 conditions)
Please see the attached sample workbook.

Is there any way to achieve this?

*In the real file, I have about 8,000 rows.

 

[Amit Punia]

Check if this works for you.

 

[PP3321]

@Amit Punia
Thank you
I also found this thread
http://forum.chandoo.org/threads/di...ng-countifs-and-sumproduct.30438/#post-181505