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