F
Frank Stone
I'm assuming that you have a list of the sales people
somewhere in the file.
beside each sale person's name enter
=COUNTIF(Range,"sale person's name")
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.
somewhere in the file.
beside each sale person's name enter
=COUNTIF(Range,"sale person's name")
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.