Leave Calculation

[nbkjytr]

Hello Everyone,
I am sorry for bothering you all, my excel knowledge is very limited.
In my company we have multiple type of leaves called as Privilaged Leave, Sick Leave, Marriage Leave, Compassionate Leave, MAT AND PAT leave and many more. For the leave tracker I want all the other leaves to be considered as Other except only Privileged and Sick Leave. How should I formulate this so I can get the overall counts for all other leaves all together except PL and SL.

 

[PeteWright]

any example?

 

[BigBeachBananas]

Try:

Book1
	A	B	C	D
1	FICTICIOUS DATA		TRACKER	COUNT
2	Privileged Leave		PL	5
3	Sick Leave		SL	4
4	Marriage Leave		Other	5
5	Compassionate Leave		TOTAL	14
6	MAT
7	PAT
8	Privileged Leave
9	Sick Leave
10	Privileged Leave
11	Privileged Leave
12	Privileged Leave
13	Sick Leave
14	MAT
15	Sick Leave
Sheet1

Cell Formulas
Range	Formula
D2	D2	=COUNTIF(A2:A15,"Privileged Leave")
D3	D3	=COUNTIF(A2:A15,"Sick Leave")
D4	D4	=COUNTA(A2:A15)-SUM(D2:D3)
D5	D5	=SUM(D2:D4)

 

[nbkjytr]

1st Dec - PL (Privilaged)
2nd Dec - PL
3rd Dec - SL (Sick Leave)
4th Dec - SL
5th Dec - MRG (Marriage Leave)
6th Dec - MRG
7th Dec - MAT
8th Dec - PAT
9th Dec - REL
10th Dec - Other
So as per above information Total PL and SL is 2 each seperately. I want rest all the leaves to to be considered as other and I want a formula which will exclude PL SL Present and Holiday from tracker and calculate the rest as one.