G
Guest
I've got a list of date thus:
date salesperson amount of sale
and a second table that I want to create thus:
salesperson number of sales average sale median sale
I can get the count by uning dcounta, but can't make the daverage function
work in this context. Is there a trick to this? And I have no idea how to
get the median. Any help appreciated.
date salesperson amount of sale
and a second table that I want to create thus:
salesperson number of sales average sale median sale
I can get the count by uning dcounta, but can't make the daverage function
work in this context. Is there a trick to this? And I have no idea how to
get the median. Any help appreciated.