Forum Discussion
Countifs
In the sheet there r 10 sales managers and they have 15 agents. Agents have done business whose amounts are mentioned. Question is- Need SM wise, how many agents have done business over 25k till date....
This would probably best be done in a pivot table. If you take the data, turn it into a pivot and use agents as row field and sales $'s as values, it'll list each agent and their total sales. Then you can right click the sales totals > sort by largest to smallest and easily see who did over 25k.
More info on your data and workbook would be helpful!
More info on your data and workbook would be helpful!