Calculating shift patterns (Sorry can't be more specific)

S

srhyllnd

I really hope that someone can help me. I'm at the end of my wits tryin
to work this one out.

I have a time sheet


M T W T F S S (ETC for 3 months)
PERSON A E E L M E O O
PERSON B O O L M M E E


E Shifts
M Shifts
L shifts
O (Off)

I want a formula that could help calculate how many people are on
certain shift on each day.

So, E shifts for M = 3, for instance, so that each time I add a shif
it automatically calculates the number at the bottom.

Also and I know this is cheeky...but does anyone know how I can tall
how many L shifts someone does in month etc. To keep an automati
check.

I would be most grateful if anyone can help with this
 
A

AlfD

Hi!

The formula =countif(A1:A100,"E") will count how many times the entr
E occurs in the range A1:A100.

The same countif approach will work within a row (for an individua
person) but you will need to be more precise as to how you are definin
periods and whether you want it to be rolling, fixed months, four week
or what.

Al
 
Top