Attendance Tracker

Hi. I have an attendance tracker created for work, on a weekly basis I need the ir attendance percentage. Im sure its pretty simplistic of a formula, and whoever gives me this answer is my God forever!

Basically, its a 5 day work week. Their attendance is marked A= Absent(0%), P=Present(20%), LS=Late Start(10%), LE=Leave Early(10%). I just need to add up the 5 days for each worker, and input it into another cell with their attendance percentage. So essentially they work 4 days = 80% attendance...3 days = 60%...etc.

If I confused anyone and you need to see a spreadsheet to understand, just ask.

Thanks SO much in advance!

Shanny

Great, worked like a charm! Thanks!!!

Yet another stupid question. So i came up with a huge formula, but its fine, its working.

=COUNTIF(C4:O4,"P")*20+COUNTIF(C4:O4,"A")*0+COUNTIF(C4:O4,"T")*20+COUNTIF(C4:O4,"LS")*10+COUNTIF(C4:O4,"LE")*10+COUNTIF(C4:O4,"LS1")*0+COUNTIF(C4:O4,"LE1")*0+COUNTIF(C4:O4,"TRN")*20

Question is I have like 80+ staff that I need to use this, I'm sure theres an easier way to shift all the cell #'s down one...like instead of C4:O4, it'll be C5:05, then C6:O6, etc...Any ideas on how I do this?

Why are you including counts multiplied by zero.....? zero*anything = 0 so can be ignored.

Ed