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:

[TABLE="width: 216"]
<tbody>[TR]
[TD]Employee #
[/TD]
[TD]Sales
[/TD]
[TD]Category
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]$33.00
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]$33.00
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]$30.00
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD]$22.00
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]13
[/TD]
[TD]$21.00
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]$20.00
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD]$19.00
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]$17.00
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]$17.00
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]$15.00
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]$15.00
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]14
[/TD]
[TD]$12.00
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]$10.00
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]$9.00
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]$3.00
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Top 5
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Category
[/TD]
[TD]Employees
[/TD]
[TD]Sales
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]1
[/TD]
[TD]$30.00
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]1
[/TD]
[TD]$33.00
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]0
[/TD]
[TD]$0.00
[/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]1
[/TD]
[TD]$33.00
[/TD]
[/TR]
[TR]
[TD]E
[/TD]
[TD]2
[/TD]
[TD]$43.00[/TD]
[/TR]
</tbody>[/TABLE]

Thanks for your help!