I'm trying to create a labor schedule which will count the number of
employees by job position by the day they work. I've figured out how to count
by Job title of employee and plug that into a specific cell, but what I'm
trying to do is calculate this based only on the day that they work.

Essentially, Bob, vince, and Ben are all managers, 2 work monday, 1 on
tuesday and 3 on wednesday. How can I filter a count of managers working day
by day based on which day they have hours logged in when there will be about
100 people all with differing job titles?

My spreadsheet is essentially a listing of the hours that are worked and
when breaks are taken so I'm trying to create a formula conditional to the
job title and based on whether hours are logged for that day or not.

Most importantly, I'd like the formula to be easy to work with and not have
to add 100 conditions for 100 employees. Is there a way to scan specific
cells? I orignally thought that a "countif" formula would work for the job
title through a general range of cells, but also adding the condition that
"Hours" be greater than zero to define a specific day worked. However I can't
seem to make it work since if any "hours" are zero then no one who has hours
for that day is listed.

Name Bob Start 12:00 AM
Position: manager foh Out 10:15 AM
Wage: $1.00 In 10:45 AM
Notes: End 9:00 PM
Hours 20.50
OT 12.50
$$$ 26.75

I think I'd use a SUMPRODUCT for this. Let's assume column B shows "MANAGER"
or "Associate" or whatever and Column C includes the hours for the day

=SUMPRODUCT(--(B2:B100="MANAGER"),(C2:C100))

HTH,
Barb Reinhardt



"Bryce" wrote:

I'm trying to create a labor schedule which will count the number of
employees by job position by the day they work. I've figured out how to count
by Job title of employee and plug that into a specific cell, but what I'm
trying to do is calculate this based only on the day that they work.

Essentially, Bob, vince, and Ben are all managers, 2 work monday, 1 on
tuesday and 3 on wednesday. How can I filter a count of managers working day
by day based on which day they have hours logged in when there will be about
100 people all with differing job titles?

My spreadsheet is essentially a listing of the hours that are worked and
when breaks are taken so I'm trying to create a formula conditional to the
job title and based on whether hours are logged for that day or not.

Most importantly, I'd like the formula to be easy to work with and not have
to add 100 conditions for 100 employees. Is there a way to scan specific
cells? I orignally thought that a "countif" formula would work for the job
title through a general range of cells, but also adding the condition that
"Hours" be greater than zero to define a specific day worked. However I can't
seem to make it work since if any "hours" are zero then no one who has hours
for that day is listed.

Name Bob Start 12:00 AM
Position: manager foh Out 10:15 AM
Wage: $1.00 In 10:45 AM
Notes: End 9:00 PM
Hours 20.50
OT 12.50
$$$ 26.75