I'd like to record employee absences on Excel and get totals of both number
of days & number of times (frequency) an employee has been absent. e.g.:

Apr = 3+1 (No. of days off = 4 & frequency = 2)
May = 1+ 1 (No. of days off = 2 & frequency = 2)
Jun = 0.5+3+2 (No. of days off = 5.5 & frequency = 3)

Any suggestions?