Hi,

Need to make a quick countif statement.

I have a column of different countries and need to count the different ones.

For example, say column j contains:

Country of Risk
BRL
USD
USD
EUR
CAD
CAD
ZAR
BEF
GBP
GBP

i want to count the amount of "different" countries without counting the reoccurring ones twice. So in this example it would return 7 countries rather than 10. An extra bonus would be able to exclude EUR in the same formula since "EURO" is not a country but a currency. Probably a piece of cake to most of you but I cant quite get it.

Thanks in advance!