Count Distinct Values Per Attribute

Hi,

I'm trying to write a formula to count the number of unique product types per client (example attached). e.g. ABC Capital LLC has two distinct product types - A and B, whereas XYZ Capital has only one product type - A.

Any help is greatly appreciated. I cannot use pivot tables to do this because I need to build on this formula to extract more metrics

Thanks