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


--
Paula M
------------------------------------------------------------------------
Paula M's Profile: http://www.excelforum.com/member.php...o&userid=26465
View this thread: http://www.excelforum.com/showthread...hreadid=397346