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?