Hi Everybody!

I am trying to find a formula that will find the unique names in one column and count their status from another.

The file I have attached gives an example.

A has names. Some names are there multiple times. B has a status of "New". Ignoring any duplicates and blank cells, I want to count how many times there is a name that has a status of "New"

Example: Marry is listed four times, each time with a "New" status. This should be counted as 1.

Example.xls