IWishToLearn
New Member
- Joined
- Dec 28, 2010
- Messages
- 30
Greetings,
I have about 100 reps that I have pulled sales data for. The sheets are set up thusly:
REP NAME MTD #1 MTD #2 MTD#3
What I need a formula to do is to sort through each column and find the top 20% of values, then sum the product into a header cell. I also need to find the bottom 20% of values and sum that product.
The idea is to figure out how much the top 20% of reps in each category is contributing and likewise how much is produced by the bottom 20%.
I have about 100 reps that I have pulled sales data for. The sheets are set up thusly:
REP NAME MTD #1 MTD #2 MTD#3
What I need a formula to do is to sort through each column and find the top 20% of values, then sum the product into a header cell. I also need to find the bottom 20% of values and sum that product.
The idea is to figure out how much the top 20% of reps in each category is contributing and likewise how much is produced by the bottom 20%.