Search This Blog

pCloud Crypto

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.

pCloud Lifetime

The customer care and complaint management contact details for BASIC Bank Limited

If you need to get in touch with  BASIC Bank Limited  in Bangladesh regarding complaints or suggestions, here are the ways you can reach the...