Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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

Answer
Discuss

Answers

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

Discuss

Discussion

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