When calculating averages based on multiple conditions, Excel provides a function called AVERAGEIFS. This is great for calculating the mean of a set of numbers. However they do not provide an equivalent for calculating the median and mode using multiple conditions.
To achieve this we will need to create an array formula by nesting the IF function within the median and mode functions.
For this example we will be using a list of real estate prices.
Conditional Median Formula
The MEDIAN function is used to calculate the middle value from a set of values. The formula below, entered in cell H3, calculates the median real estate price for a specific town.
