View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default Special count.,,

I agree with Ashish Mathur, things are not clear. Ms-Exl-Learner's solution
will work IF you actually have the phrases in a column, but if those are not
there, then we need more information:
Why would the entries at rows 15 and 18 not be included in the count? How
do we know they're not a single day of illness?

"Flemming" wrote:

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