Median of range of numbers with criteria

[lost_in_the_sauce]

I'm creating a report on finances of different locations, and have AverageIF, MaxIf, and MinIf knocked out, but there isn't a MedianIF.

I only have 1 condition to check, it's the column that has the location's state

The other ones are just =AVERAGEIF(C:C,"CA",E:E), so nothing really complicated. If I wanted to take the median of all locations that had CA in column C instead of average, how could I do that?

 

[Fluff]

How about

=median(filter(E:E,C:C="CA"))

 

[lost_in_the_sauce]

How about

=median(filter(E:E,C:C="CA"))

It did, thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.