Formula for Averaging Array Given Multiple Criteria

Hi -

I am looking for a formula that averages the numbers in an array if they match the row and column text-based criteria. Based on another thread, I found and edited the following formula. However, it is giving me incorrect numbers.

[=AVERAGE(IF(($A$3:$A$275=$P6)*($B$2:$M$2=Q$4),$B$3:$M$275))]

I have attached a sample workbook that includes the broken formula. Please let me know if you have any thoughts. All help is greatly appreciated.

That seems to work perfectly with two criteria. However, it produces the wrong value when I add a third criteria. Any thoughts?

Hi XOR - thanks for your help.

This is the 3 criteria modification. (I am using the original, not test file. Let me know if this is an issue).

=AVERAGE(IF(AllData!$D$4:$D$298=Status!$B4, IF(AllData!$A$4:$A$298=Status!$A$3, IF(AllData!$G$1:$CB$1=Status!C$3, IF(AllData!$H$4:$CC$298<>"",AllData!$H$4:$CC$298)))))

Thanks!