I have been trying to use array formulas without any success. I haven't got the add in feature of conditional sum wizard and would like to know where i am going wrong.
I have got a number of columns and would like to count the no of eligible males. Column M3: M250 (eligibility) either is YES or No and Column AF3 :M250 (Gender) either is MALE or Female
I have written the formula
=Sum(($M$3:$M$250="YES")*($AF$3:$AF$250=MALE)
I should point out that i have add the braces{}using control, alt delete
I have got a number of columns and would like to count the no of eligible males. Column M3: M250 (eligibility) either is YES or No and Column AF3 :M250 (Gender) either is MALE or Female
I have written the formula
=Sum(($M$3:$M$250="YES")*($AF$3:$AF$250=MALE)
I should point out that i have add the braces{}using control, alt delete