# Attendance Tracker

1. ## 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.

Shanny

2. Hi,

Presuming your attendance data is in row 1 from column A to E,

=COUNTIF(A1:E1,"P")*20+COUNTIF(A1:E1,"LS")*10

will yield the attendance score you are trying to calculate.

3. Great, worked like a charm! Thanks!!!

4. 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?

5. Originally Posted by shanny
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?
2007 does it auto, try fill down, control D, if not copy past from mine

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

Ed

7. I seen that but I did not relize, it lol... Dunno, I was just helping

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1