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

which must be confirmed with control+shift+enter, not just with enter.

Paula M wrote:
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