COUNTIF

  • Thread starter Thread starter Leanne
  • Start date Start date
L

Leanne

Hi all,

I'm trying to count the number of hours worked by some
employees and have the payroll numbers in col A and total
hours in Col B. I need to now count the number of
employees who have worked <50 hours, 51-100, 101-150 etc.
I have worked out the Countif formula for <50 but am not
sure how to exclude numbers outside of a bracket such as
51-100 without having to subtract the value of the <50
within the formula.

Please help...

Thanks
Leanne
 
Sorry Don,

I don't want to add the hours up... I want to count the
number of employees with <50, 51-100, 101-150 etc hours
worked, I have already added their total hours up.

Also, when I did a nasty looking formula that looked
something like =COUNTIF(C:C,"<150")-SUM(F2:F3) in order to
count the number of eployees with <150 hours but not the
ones who had under 101 hours which were already counted
in "F3" and <50 from "F2" and then dragged to populate the
other cells it all went pear shaped!!!.... is there a way
of being able to populate the cells automatically.

I have a heap of worksheets to go through in this way,
some of which will need to count the number of employees
within 50 point increments up to 1200.
 
Back
Top