# Get median of one column, with multiple criteria

0

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.

Thanks,

Toni

0

"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.

### Discussion

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