Thanks Hemesh and Saarang84.

This works great with the data example I provided but when I tried to apply it to my data it returns NA.

Perhaps this is because the customer ID I initially gave you is too simplified Eg 1,2,3...etc.

My actual ID's are a letter followed by numbers.

If you are able to, please take a look at my updated example. Now I am quantifying the emails sent by date and using a little tweak to your formula (removing the date criteria) to give me the total emails sent from each employee.

This all works well with my initial example - Once I change the format of the customer ID's it returns 0?

Any pointers much appreciated.

Thanks
Sample Work Updated 2.xlsx