Hello All, I kind of know how the countif function works.

I need to know how many different names appear in Column A, based on the value of Column B.

So in Column A:B I might have

Adam Apple
Gary Orange
Pete Orange
Adam Orange
Gary Apple
Phil Apple
Craig Apple
Adam Apple

I want to count the unique names in column, that seelct apple - so in this case 4 (as adam apepars twice)

I know how to do =countif(B:B,"apple") but what do i need to add to calculate unique occurances in Col A.

Thanks