averageifs question

[saimike]

I am trying to find the average of some rows in a long array of records.

averageifs does an average of a cell if the boolean AND of all the criterias are met, i.e. average if A=X AND B=Y AND C=Z. I need a combination of boolean AND and OR, eg: average if (A=X) AND (B=Y OR C=Z). How would I do this?

[Domski]

Try: =AVERAGE(IF((A1:A10="X")*((B1:B10="Y")+(C1:C10="Z")),D1:D10))

Confirmed with Ctrl+Shift+Enter as it's an array formula.

Dom

[saimike]

Domski, thanks!