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)*(DFAData!$I$8:$I$1000=$C$15)*(DFAData!$H$8:$H$1000="CONVO"),DFAData!M$8:M$1000))

-DP