4 criteria average returning error

[chriswrcg]

I am trying to average a range of figures with 4 criteria. I have tried two formulas and both are returning errors.

[Limor_OP]

Hi,

In Q4 try this:
=AVERAGE(IF((D1:D300=$O$2)*(L1:L300=$P$2)*(A1:A300>=$Q$2)*(A1:A300<=$R$2),I1:I300))

In Q5:
=AVERAGEIFS($I$1:$I$300,$D$1:$D$300,O2,$L$1:$L$300,P2,$A$1:$A$300,">="&Q2,$A$1:$A$300,"<="&R2)

[wk9128]

Array formula

{=AVERAGE(IF(($D$6:$D$232=O2)*ISTEXT(IF($L$6:$L$232=P2,$L$6:$L$232))*($A$6:$A$232>=Q2)*($A$6:$A$232<=R2),$I$6:$I$232))}