DAVERAGE function with examples in Excel

The DAVERAGE function in Excel calculates the average of selected data based on specific criteria. Let’s explore some examples:

1. Average Salary of Employees in a Department: Suppose you have a dataset with columns for “Salary” and “Department.” To find the average salary of employees in the “Sales” department, use this formula:

   =DAVERAGE(A2:C11, "Salary", A2:A11="Sales")
   

   This will give you the average salary for Sales employees.

2. Average Age of Female Employees: If you want to calculate the average age of female employees, assuming the gender is in column C, use:

   =DAVERAGE(A2:C11, "Age", C2:C11="Female")
   

   This formula provides the average age for female employees.

Remember, the DAVERAGE function is handy for analyzing data subsets.