Ok... I've placed a test file that has the data in it for my question.
Right now I'm using the following macro to have the program sum column E within each department and place the total of the department in column H in the blank row after the last person in the department.
This takes care of my totals for the following:Please Login or Register to view this content.
Total (Column H) which totals RegHours (Column E)
Regular Total (Column I) which totals Regular Hours (Column F)
Overtime Total (Column J) which totals Overtime Hours (Column G)
Now what I need is to have a countif function that tells me using Regular Hours (Column F) if the employee's hours are greater than zero in each department, so I can know how many people actually worked this week in that department, and this would be in Employee Count (Column K) next to all the other totals.
The other thing I need, which would be very similar to the above need, is another countif function within a macro that looks at Overtime Hours (Column G) and does another countif greater than zero to tell me the number of employees that had overtime hours and that total would be in Employee's w/Overtime (Column L).
My problem arises from the fact that each week we delete people and add people to these departments and it cannot be a simple =countif(F2:F25,">0") and =countif(G2:G25,">0").
I'm sure I can manipulate the macro coding posted above to do this but I have played with it and cannot figure it out.
Any and all help would be greatly appreciated.
Thank you all in advance!
Bookmarks