Good deal. I was able to guess it! Thank you for the response!

"Newfie809" wrote:

Hi Sean Timmons, I used the sumproduct one and it worked. thanks
--
Newfie


"Sean Timmons" wrote:

Are you saying you have a list of 50 employees, in column A, and the number
of hours in column B?

then it could be =countif(B:B,"=10")

Or, are you saying there is a list of all employees, 50 of which, in column
a, state Union, Non Union?

then, something like:

=SUMPRODUCT(--(A2:A1000="Non Union"),--(C2:C1000=10))

May be easier if we had a few rows of data.

"Newfie809" wrote:

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