Countif / Sumif & Large

[poly1]

Of the top 113 (out of 450) employees based on sales, I need to count the number of employees and sum their sales in each category.

I have a list of 450 employee numbers along with their corresponding sales and assigned category.

On another tab, ONLY for the top 113 employees I need to:

1. Count the number of employees in each category
2. Add the sales related to each category

An abbreviated example looking at the top 5 out of 15 is below:

Employee #	Sales	Category
5	$33.00	D
8	$33.00	B
2	$30.00	A
12	$22.00	E
13	$21.00	E
7	$20.00	A
15	$19.00	D
3	$17.00	B
6	$17.00	E
1	$15.00	A
9	$15.00	A
14	$12.00	C
4	$10.00	C
10	$9.00	B
11	$3.00	D
Top 5
Category	Employees	Sales
A	1	$30.00
B	1	$33.00
C	0	$0.00
D	1	$33.00
E	2	$43.00

<tbody>
</tbody>

Thanks for your help!