Recording Absences

H

HarryHeathrow

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

Roger Govier

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)
 
B

Bob Phillips

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))
Click to expand...

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)
 
B

BRABUS

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