I’m a little confused on this. 

I have an array of data that was generated by conditional “AVERAGEIFS” with locations by row and differing conditions by column. The data is pulled from a different page. 

=AVERAGEIFS(Data!$AL:$AL,Data!$A:$A,”FG-*”,Data!$F:$F,”CRITERIA1″,Data!AL:AL,”<100″,Data!AL:AL,”>0″,Data!$G:$G,”CRITERIA2″)

This part works great

I’m trying to get basic statistics on each column.

Not every location has the conditions so I have #DIV/0! errors mixed through the data.

I am trying to get the median of the column. (and am hoping STDEV functions the same way)

Despite what MS says… =MEDIAN(C4:C88)  just gives me a #DIV/0! error. 

I’ve tried multiple IF functions but it seems that having the criteria data in the same column as the range for MEDIA is causing issues.  

Any ideas?

Thanks

​I’m a little confused on this. I have an array of data that was generated by conditional “AVERAGEIFS” with locations by row and differing conditions by column. The data is pulled from a different page. =AVERAGEIFS(Data!$AL:$AL,Data!$A:$A,”FG-*”,Data!$F:$F,”CRITERIA1″,Data!AL:AL,”<100″,Data!AL:AL,”>0″,Data!$G:$G,”CRITERIA2″)This part works great I’m trying to get basic statistics on each column. Not every location has the conditions so I have #DIV/0! errors mixed through the data.I am trying to get the median of the column. (and am hoping STDEV functions the same way)Despite what MS says… =MEDIAN(C4:C88)  just gives me a #DIV/0! error. I’ve tried multiple IF functions but it seems that having the criteria data in the same column as the range for MEDIA is causing issues.   Any ideas? Thanks     Read More

​