Hi Mark,

Try

=SUMPRODUCT((C1:C1000)*(A1:A100="Temp")) to count the number of temp
employees with hours more than zero.

Change "Temp" to "Perm" to do the same for Permanent employees. You dont
have to worry about the blank rows with no data (Rows 23 to 39 etc.).
Just make sure you cover the entire range where you have the data.

Regards

Govind.

Mark wrote:

I am trying setup a CountIf function where the following range and count
exists:

Column A Contains word "perm" or "term"
Column B Contains employee name
Column C Contains Number of hours worked - my be null value if employee
did not work.

I want a cell that counts the number of "term" or "perm" employees where the
value in Column C is not null or the value is 0. When ever I try to write
the count if it tells me that I am limited to one range as opposed to
multiple ranges: ie. A3:A22, A40:A75 because the employees are broken up
into teams. If need be I can dismantle the team setup but I would loose
pertinent information about each team. Then again, if the countIf function
works, then I can set up a countif cell that performs based on the multiple
ranges.

Hope this isn't too confusing.

Mark