Excel Formulas to use Conditional median with criteria in Excel!!

Here, we will guide you to learn the simple and useful formulas to use conditional median with criteria in Excel. You can also learn the basic syntax with brief explanations. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula

• To use conditional median with criteria in Excel, use the below-mentioned formula.

{=[MEDIAN](https://geekexcel.com/how-to-use-excel-median-function-in-office-365-with-examples/)([IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(criteria,range))}

Syntax Explanation

• MEDIAN – This MEDIAN function returns the median (middle number) from the given set of input numbers.
• Parenthesis () – The main purpose of this symbol is to group the elements.
• **Comma symbol (,) – **It is a separator that helps to separate a list of values.
• *Range * – It represents the input range.
• IF – The IF function return one value for a TRUE result, and another for a FALSE result.

Practical Examples

Let’s consider the below example. Here we are going to use conditional median with criteria in Excel.

• For instance, you have to create a sample data in Excel.

Sample data

• To calculate a conditional median, you need to use the following formula in formula bar.

{=[MEDIAN](https://geekexcel.com/how-to-use-excel-median-function-in-office-365-with-examples/)([IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(group=E5,data))}

Use the Formula

• Then, you have to press the Ctrl+Shift+Enter key to get the result in the cell F5 as shown below.

Result for cell F5

• Now, you need to press Ctrl+D key to get the results in all other columns.

Output

Verdict

In this tutorial, we explained the formulas to use conditional median with criteria in Excel. Hope that this tutorial is useful to you. Mention your queries in the comment box below. Click here to know more about Geek Excel!! *And Excel Formulas *!!

Related Articles:

• Excel Formulas to Calculate the Work Hours between Dates and Times!!
• Excel Formulas to Apply Conditional Formatting based on Another Cell!!
• Formulas to Apply Conditional Formatting based on Another Column!
• Formulas to Highlight Bottom Values with Conditional Formatting!!
• How to do Conditional Formatting using VBA in Microsoft Excel?