Count unique values in columns based on 2 criteria

Excel 2013
I am trying to calculate the following values. The spreadsheet is attached.

Unique Emails 7 (formula I am using is below)
count of phones without emails (answer is 1)
count of UNIQUE emails without phones answer is 3
count of UNIQUE emails with phones answer is 4



Column A Column B
[email protected] (212) 888-8888
[email protected]
ddd@gmail
[email protected] (203) 555-1212
[email protected] (203) 555-1212
(312) 888-2222
[email protected]
[email protected] (212) 999-7777
[email protected]
[email protected] (312) 444-2222


=SUM(IF(FREQUENCY(IF(LEN(A6:A15)>0,MATCH(A6:A15,A6:A15,0),""), IF(LEN(A6:A15)>0,MATCH(A6:A15,A6:A15,0),""))>0,1))

based on your sample file - all to be ARRAY-entered, except the one with COUNTIFS:

Unique Emails

Please Login or Register  to view this content.

count of phones without emails

Please Login or Register  to view this content.

count of UNIQUE emails without phones

Please Login or Register  to view this content.

count of UNIQUE emails with phones

Please Login or Register  to view this content.

shy, Im sorry to have to do this, but...
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.