formula help for leave summary of attendance sheet

[rahulshewale1]

Dear Sir...

please find the attached sheet of attendance. i want formula to extract cl,lwp,ab(leave summary). i have attached Result also.every month i do manually please help .

 

[NARAYANK991]

Hi ,

See if this gives you correct results ; check thoroughly.

Narayan