How to find the average age of male employees in Excel

How to find the average age of male employees in excel

1. Open the EXCEL table that needs to be operated and enter the function in the target cell of the average age of males=AVERAGEIF(, and then click to select the cell in the area where the gender is located, such as B2:B15. [The cell where the employee’s gender is located can be changed according to the actual situation.]

Recommended: excel basic tutorial

#2. Continue to enter the function "male", then click to select the cell where the age is located, such as C2:C15), and press Enter to complete the average age of male employees. Calculation formula editor. [The cell area can be modified according to the actual situation in the same way]

3. Similarly, the average age of female employees can be found =AVERAGEIF(B2:B15,"Female" ,C2:C15).

4. Return to the EXCEL table and find that the calculation of the average age of male and female employees in Excel is completed.

For more excel-related tutorials, please pay attention to PHP Chinese website!

The above is the detailed content of How to find the average age of male employees in Excel. For more information, please follow other related articles on the PHP Chinese website!