Hi all,

Just to note - I am using these numbers as an example. I am working on excel 2003. Please see attached image, hopefully if it uploads correctly.

So I want to calculate productivity of my employees "AA,BB,CC,DD" by the day. So for example I would like to calculate how many times AA sent an email to customers on 5/26/2014. Some customers have more than 1 account. I don't want to count each customer more than once. I also don't want to count customers with 0 Outstanding Documents.

So how I am doing this is using countifs as shown below. My only issue is how to not include duplicates from Column A - "Customer ID"

=COUNTIFS($C:$C,$G3,$D:$D,">0",$E,H$2)

This formula works for everything I need, I just need to not count customer ID's more than once.

Can anyone advise me on the easiest way to fix this? Not just a simple filter or pivot table as I am well aware of that, it needs to be incorporated into the formula.

Any help much appreciated.

ThanksScreen Shot 2014-05-26 at 8.57.37 PM.png