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?

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?

Harry,

If you are asking to count blocks as one entry, then you could use something
like

=SUMPRODUCT(--(TEXT(A2:A200,"mmmyyy")="Apr2006"),--(B2:B200="A"),--(B2:B200<
B1:B199))

but we would need to have a better idea of the data to give a comprehensive
anser, such how you record the absences, how a day or half day is
differentiated, etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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?

You could get the total by using the SUM function and
the qty/frequency by using the COUNT function to get the results you
want.




--
BRABUS