Hi!
I'd appreciate your help with a formula. I'm trying to get the avarage ages of all the people on a list that meet two different criteria. The Ages are in column F and the criteria are in in columns A and B.
Could you please tell me what's wrong with my formula? I'm entering it as an Array formula.


{=IF(((ARGENTINA!$A$1:$A$995="S")*(ARGENTINA!$B$1:$B$995="H")),AVERAGE(ARGENTINA!F5:F999),0)}

Many thanks

Paula