I am trying to get the average of sales per person depending on the distinct count of the customer name. I have attached the file, this is a basic average if formula.
You currently have the average sales per customer for every ship date. Just remove the ship date and you should have what you need. Is that what you are looking for, unless I did not understand your question?
Retrieving data ...