Believe or not, I have encountered this problem quiet many times - "How to get the count of unique items from a column from a table that has duplicate records or has multiple layers.

In this tutorial I will show you how to use an array formula to get the unique count based on a criteria.