Can someone help me with this one, thanks

If I have a Group of Employees Listed by Departments and wanted to know how
many employee in each group have more that 10 days off.

Example. Non Union Group there are 50 Employees each employee has anywhere
from 1 to 40 days off, but out of the 50 employees there are only 2 employees
with more that 10 days.

I am looking for a formula Countif the Non Union Group =10 and it brings
back the number of employees 10 or over, which should be 2.
--
Newfie