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
Bookmarks