Hi everyone,
I spent a lot of time trying to find the correct formula I needed but didn't find anything.
I want a formula to find how many countries has RED as colour while excluding repetition of countries. So the formula needs to count the number of countries in the column "country" that has RED in the column "colour" all while excluding the repetitions in column "country"
For example below it would be 3 countries : Mexico (twice but I want it counted as 1) India and China
Can anyone help ?
Thank you
J.
Country---Colour
Mexico---Red
Benin---Orange
Canada---Blue
Mexico---Green
India ---Red
Mexico---Red
China---Red
Bookmarks