Thread: Multiple Criteria Means and Multi-Sheet References

Heyo,

I want to create a table that automatically populates the mean value for several dimensions of my data based upon a multi-criteria condition, i.e., all the data that matches 4 specific selections made from a group of drop downs. I've created a Median with an If clause, but I keep getting N/A (I'm aware of the array entry requirement". This may require me sending the doc, but I thought maybe I've exceeded the number of conditions allowed for this function. Not sure.

Heres what I have: (I've checked all the references and they align)

=MEDIAN(IF((DFAData!$C$8:$C$1000=$B$13)*(DFAData!$D$8:$D$1000=$C$13)*(DFAData!$J$8:$J$1000=$B$15)*(D FAData!$I$8:$I$1000=$C$15)*(DFAData!$H$8:$H$1000="CONVO"),DFAData!M$8:M$1000))

-DP

the mini criteria are reporting true/false, you might want to add an AND function in the begining to combine them all, replace the multiplication star with a comma, and add in a IF FALSE output.

If you want to return the median, start off with an IF function, make the logical test AND(1,2,3,4,5). If true, Median(median(DFAData!Range),median(DFAData!Range),and soforth. And, for the FALSE statement, report something like "Did not pass", or whatever you want in it.