How to count one column's values without another column's duplicates affecting it

Hello there! Here are the details about the problem I have:   I want to count the number of values in one column, without another column's duplicates affecting it.  Example: I have a table with ...