Staff Levels

[Peppi S.]

I have created a spreadsheet showing my 8 employee's time for each day of the
month. On each day, the employee has the shift they work (1, 2 or 3), then
any time they accrue as overtime, time they take off and time they adjust.
They all work 3 different shifts, but sometimes an employee occasionally
adjusts to a different shift.

I am needing to determine daily staffing levels. I need to look at what
shift each person worked on each day and determine how many people worked
1st, how many 2nd and how many 3rd. I can't use the IF formula due to having
more than 7 employees. I looked at the LOOKUP & VLOOKUP function, but don't
think that's what I want. I am thinking I need to look at each cell on each
day and determine if it is blank or black, it means they took leave that day
(blank) or was off that day (OFF or black), then determine if there are two
"1's" that day, then that would be 2 people on 1st shift that day and so on.

I know I'm probably making it harder than I need to, but with the limitation
of 7 calculations on the IF function, I don't know how do to that using
LOOKUP or VLOOKUP. Can any help me? Thank you!

 

[MyVeryOwnSelf]

... I looked at the LOOKUP &

VLOOKUP function, but don't think that's what I want. ...

Maybe COUNTIF() and SUMIF() are a better fit here.

 

[Bernd P]

Hello,

Maybe my UDF Pfreq can help you here:
http://www.sulprobil.com/html/listfreq.html

Regards,
Bernd

 

[Peppi S.]

Thanks to all who have responded. I'll try those suggestions and see if that
fits better. Thanks again!