Excel Calculate the Median IF – Two Methods | Function and PivotTable

Microsoft Excel Tips and Tricks

I love the Median Function in Excel, but I want to use it conditionally. For example, I want to calculate the median salary of the Accounting department, or what is the median price of homes in Atlanta, GA?

Credit Chris Menard