Attendance Spreadsheet

[HR_Jen]

Hello everyone,

I have a spreadsheet to track reasons for absences, ie:

A Absent
B Bereavement
D Discipline
L Late
LE Left Early
LOA Leave of Absence
J Jury Duty
C Citizenship

The employees name is on the left hand side, then the dates of the month. I would enter one of the above codes that would corresponde with the date where the absence occurred. On the right hand side of the sheet, I have columns for the totals of the above reasons. I need a formula that would look at the previous cells and count all the As, then another column that would count the Bs, and so on.

I just need the first formula and then I can modify it from there.

Thank you in advance!

 

[daniels012]

Not sure if this is what you want :

=COUNTIF(B6:B100,"A")

This counts All occurances of A in column B starting at B6

Michael

 

[erik.van.geit]

Hi, HR_Jen
Welcome to the Board !!!!!

take a look at the function COUNTIF

kind regards,
Erik

 

[HR_Jen]

Perfect!

Thank you Michael!

 

[HR_Jen]

Hi, HR_Jen
Welcome to the Board !!!!!

Thanks Erik!

I'll be back, I'm sure!

 

[Ged]

I think COUNTIF will give you the number of occurences of an item, the SUMIF function will sum the items.