Hi all,

I have column that tells me if a person have been ill on a given date.

Column Y (Y11:Y42) contains TRUE if ill and FALSE if on work.
Column Z (Z11:Z42) contains weekday as a number 1=monday 5=friday only
showing numbers if ill.

I would like know who many times an illness is a single day only...!

Y Z
11 FALSE
12 TRUE 2 (single day of illness)
13 FALSE
14 FALSE
15 TRUE 5
16 FALSE (not at work it the weekend)
17 FALSE (not at work it the weekend)
18 TRUE 1
19 FALSE
20 TRUE 3 (single day of illness)
21 FALSE
22 FALSE
23 TRUE 5 (single day of illness)
24 FALSE (not at work it the weekend)
25 FALSE (not at work it the weekend)
26 FALSE

Result should then be 3 times

Can this be done without using VBA?

Thanks,
Flemming