Count of ID compared to Average

[Caitlin_Knox]

I am trying to solve what seems like a simple calculation but can't quite figure it out. I've successfully modeled out what I'd like in Excel. Essentially, I want a table that shows the Sales Support person's name, the count of ID's, and then the total average of ID's, with a fourth column that shows the difference between the average and their count.