Can you please help me with finding the count of distinct (case sensitive) products sold (Column B) per store (Column C) as per below data? Product_sold column has data from B2: B10. Store column has data from C2:C10. F2:F5 has the resulting expected values that the formula should calculate.
In Column F2, I want a formula which counts the distinct count (case sensitive) of product sold for the store “Costco”. The answer should calculate to 2 in F2. Image of Table with values attached in the linkIs there a way using SUMPRODUCT and EXACT to calculate distinct count(including case sensitive data) in Column B corresponding to the values in Column C?

I have the below formula which only looks up the range of B2:B10 and counts the occurrences of the value in B2. However, I am not able to expand this formula to make it look for the corresponding values in Column C and then calculate the distinct (case sensitive) count in Column B based on the value from Column C.

=SUMPRODUCT(–EXACT($B$2:$B$10,B2)) –> Is there a way to expand this formula maybe using IF statement and make the formula lookup the range in Column C?

Image of Table with data is in the link above.

Thanks,
KJ