Get median of one column, with multiple criteria


I am not a expert, but have a sort of decent working knowledge of formulas.  I am now trying to figure out how to calculate the median of one column, with multiple criteria from other columns.  For example:  I would like the median in column R, for 4th grade ELA, Y Gifted (see attached spreadsheet).  

I can get an average, no problem (=averagesifs), but it does not appear that =medianifs is a thing, and I can't for the life of me figure out how to embed "ifs" and populate the table in my spreadsheet.

Any help is appreciated.  Keep in mind, I'm teaching myself on the fly and won't know a lot of the lingo.





Selected Answer

"Median" is the middle value in a series of numbers. The only way to find it is to sort the numbers. There is no MEDIANIF in Excel, perhaps because the required filtering and sorting would be too big a task for a simple function.

To solve your problem you would first have to create a filter using your IF conditions, then apply the MEDIAN() function to the resulting list.



Drat!  I was afraid of that.  Thank you for your response!
vonderto (rep: 4) Oct 14, '19 at 10:48 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login