Try...

=AVERAGE(IF((ARGENTINA!$A$1:$A$999="S")*(ISNUMBER( MATCH(ARGENTINA!$B$1:$B$999,{"C","H"},0))),ARGENTI NA!$F$1:$F$999))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Paula M Wrote:
Hi,
I need your help again. Now, I need to know the avarage age of the
people belonging to the Sales deparment that are either category "C" or
"H".
Column A has the different departments (S, F, D, E, etc), column B, the
different categories (C, H, B, etc), and column F has the employee ages.

I thought of this:

=((AVERAGE(IF((ARGENTINA!$A$1:$A$999="S")*(ARGENTI NA!$B$1:$B$999="C"),ARGENTINA!$F$1:$F$999)))+(AVER AGE(IF((ARGENTINA!$A$1:$A$999="S")*(ARGENTINA!$B$1 :$B$999="H"),ARGENTINA!$F$1:$F$999))))/2
Entering it with Ctrl+shift+enter as an array formula.

It works fine when both averages are greater than 0, but it is no good
when one of them is 0. Any ideas to solve my problem? All suggestions
are welcomed!

Thanks for your help!


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