Have Column B which has those numbers that are repeated
B7 993925968
B8 993925968
B9 993925968
B10 993925968
B11 992308642

I have column C which has a specific text message =
Blast Email

Now i need to get the Distinct Count of Column C
Since the numbers are repeated in column B, then the count for column C message should be 2.

But my formula =COUNTIF($C$9:$C$90,"Blast Email") does not work for me.

Attached an excel sheet with the example

Attached Files

Analysis Summary Report_Excel.xlsx (10.4 KB, 13 views)