Hi Harry

with your data in say B1:M1
=SUM(B1:M1) will give total days off
=COUNT(B1:M1) will give frequency

If you are saying you want the total text displayed as your result, then
="No. of days off = "&SUM(B1:M1)&" frequency = "&COUNT(B1:M1)

--
Regards

Roger Govier


"HarryHeathrow" wrote in
message ...
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?