Good afternoon everyone,
I have searched and tried a lot of the solutions on the site but have yet to find a solution for the problem I face. I am trying to summarize a count based on multiple criteria.
Column A: Sales Rep
Column B: Customer
Column c: Customer Type
I was able to use this function to find the number of unique customers per sales rep. E3:E4 is the reference for the sales rep name. This is an array function.
=SUM(IF(FREQUENCY(IF($A$3:$A$27=E3,IF($B$3:$B$27<>"",MATCH("~"&$B$3:$B$27,$B$3:$B$27&"",0))),ROW($B$3:$B$327)-ROW($B$3)+1),1))
Now I need to find the number of unique customers per sales rep by customer type. For example: Joe is the sales rep. He has 13 customers but only 9 unique customers. Each customer type is either new or existing. I need to know how many unique new and existing customers each sales rep has.
I attached a sample spreadsheet in the hopes someone can make sense of the ramblings above. Any help would be greatly appreciated.
Thanks,
Frank
Bookmarks