if you create a pivot table with SalesPersons as the lone row filed and
Count of SalePersons as the sole data field, you will get a listing of
salespersons and how many times they appear. Does this help?

--
Regards,
Tom Ogilvy


"Kevin McCartney" wrote in
message ...
I need to count or ascertain the frequency of a field. The pivot table
contains a Region, Country, Sales Team, Sales Person, Client, Product. I
need to count the number of Sales Persons, a simple count on the pivot table
doesn't help because it counts the number of rows and not the frequency, the
number of sales persons. E.g. I have know I have 75 sales persons but 20000
records my grand total of sales persons should be 75. Any help on how to
calculate the actual number of Sales Persons would be great.

TIA
KM