Formula Help when calculating Absence

[Kerryt]

Hi All,

This spreadsheet has been driving me utterly mad for the last week. It has been created to be a master record of employee attendance.

I have managed to tailor a template to meet our requirements, added in various formulas etc (see attached).

However I also require an accumulative report that HR staff can copy and add to Executive reports for management. Nothing fancy just a SUM of staff members sick leave, annual leave, late days, all By Month.

=COUNTIFS(F$14:F$379,"=h",$BI$14:$BI$379,"=1")

The yearly accumulative total counts half days as well =COUNTIF(F$14:F$109,"H")+(COUNTIF(F$14:F$109,"=HD")/2)

How do i count half days in my monthly totals as well?

Any improvements to reporting tab would be appreciated. I dont know if I am doing this the hard way.

Thanks Guys