# Conditional Average in Excel (Complete Guide)

Get FREE Advanced Excel Exercises with Solutions!

In this Excel tutorial, we will learn how to calculate conditional average in Excel. We can use the AVERAGEIF or AVERAGEIFS function for this purpose. Conditional averages involve calculating the average of a subset of data that meets specific criteria. This is particularly useful when you want to analyze a portion of your dataset that satisfies certain conditions without including the entire dataset in your calculations.

## How to Apply AVERAGEIF Function to Calculate Conditional Average in Excel

Here, we will show two examples of using the AVERAGEIF function to calculate conditional averages. We will use the following dataset here. It contains departments and the annual salaries of a few employees.

### Example 1: Apply AVERAGEIF Function for Text Condition

Here, we will calculate the average salary of the employees who are from the Sales department. For that, apply the following formula in cell C19.

`=AVERAGEIF(D6:D16,C18,E6:E16)`

### Example 2: Use AVERAGEIF Function for Numerical Condition

Here, we will calculate the average salary of employees with an annual salary of over \$100000. Apply the following formula in cell C19.

`=AVERAGEIF(E6:E16,">"&C18)`

## How to Use AVERAGEIFS Function to Calculate Average with Multiple Conditions

Here, we will calculate the average salary of the employees who are from the Sales department and have an annual salary over \$100000. For that, We will use the AVERAGEIFS function. Apply the following formula in cell C20.

`=AVERAGEIFS(E6:E16,D6:D16,C18,E6:E16,">"&C19)`

This concludes our article on how to calculate conditional average in Excel. We used the AVERAGEIF and AVERAGEIFS functions for this purpose. We hope this article was helpful to you. Let us know your feedback.

## Conditional Average Excel: Knowledge Hub

<< Go Back to Calculate Average in Excel | How to Calculate in ExcelÂ | Learn Excel

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Seemanto Saha

Seemanto Saha graduated in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. He has been with ExcelDemy for a year, where he wrote 40+ articles and reviewed 50+ articles. He has also worked on the ExcelDemy Forum and solved 50+ user problems. Currently, he is working as a team leader for ExcelDemy. His role is to guide his team to write reader-friendly content. His interests are Advanced Excel, Data Analysis, Charts & Dashboards, Power Query,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF