I have a worksheet with data in several columns. I would like to use the COUNTIF function to extract some numbers. The column headers are, for example, A1 = SEX, B1 = DateOfBirth, C1= Male older than 20, C2 = Female older than 20. The cells A2 to A100 are filled with either “Male” or “Female”. The cells B2 to B100 are filled with birthdates entered in the DD.MM.YYYY format.
I would like to put the condition “=COUNTIF(A2:B100, IF(B2:B100>31.12.1980 & A2:A100 = “Male”)” to extract the number of males older than 20 years and so on.
Is that possible? I have looked through the help files but it does not show me whether it is possible.
Thanks in advance.
