COUNTIF

[LaDdIe]

Hi Members,

I've created a monthly employee sick log, which lists the days of the month
along row 3, with the day of the week at row 4 and a drop down validation
list at row 5 which can either show 1.0= full day sick, 0.5= Half day sick &
WHS= Went home sick. I know how to COUNTIF and sum all occurrences of 1.0,
0.5 & WHS, but I can't quite figure out how to sum all occurrences based on
day of the week and 1.0, 0.5 or WHS.

I.E January 07 has 5 mondays , and I would like extract how many times 1.0,
0.5 and WHS occurred on a monday. To see what day of the week is popular for
taking as sick,

Any helpful pointers in the right direction please.

Repectx.

Laddie.

 

[Teethless mama]

=SUMPRODUCT(--(WEEKDAY(A1:A100)=2),--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2007))