Multiple Data Pieces

Hi Everyone, just wondering how I would go about solving this, I have a data set with quite a bit of information, at the moment I am only trying to make a connection between C and H Date and Sales Associate, I was wondering if there was any way to find out how many entries each sales associate had on a given day, without making a pivot table and have this information update in another file automatically. I have attached a sample, any help would be truly appreciated.
Thanks!