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