Calculating the overall absenteeism rate

[v1icki]

Hello all! Any help is appreciated as I am new and trying to figure out things in excel.
I am trying to calculate the overall absenteeism rate for a particular month. (%)
Given facts:
Absenteeism rate = the amount of absences divided by the amount of total planned working days. Result is a percentage.
Legend: Shifts = number 0-99. Planned Vacation = 100 - 999. Day Off = R. Absence = A/A.
I have included part of the variables.
Ty

 

[Toadstool]

Hi V1ickki,

Is this what you want?

Book1
	A	B	C	D	E	F	G	H	I	J
1			Absenteism=	15.52%
2
3	Language	01-Jan-18	02-Jan-18	03-Jan-18	04-Jan-18	05-Jan-18	06-Jan-18	07-Jan-18	08-Jan-18	09-Jan-18
4	English	1	1	1	R	18	18	18	R	39
5	English	101	101	101	101	101	101	R	R	R
6	English	A/A	60	60	60	R	18	18	18	18
7	English	A/A	60	60	60	R	18	18	18	18
8	Dutch	1	60	60	60	A/A	18	18	A/A	18
9	Dutch	1	60	60	60	A/A	18	18	A/A	A/A
10	Dutch	1	60	60	60	A/A	18	18	18	18
11	Dutch	1	60	60	60	A/A	18	18	18	18
12	Dutch	1	60	60	60	R	18	18	18	18
Sheet1

Cell Formulas
Range	Formula
D1	D1	=TEXT((COUNTIF($B$4:$J$12,"A/A")/COUNTIF($B$4:$J$12,"<100")),"##.##%")
C3:J3	C3	=B3+1