Question

If I wanted to find the mean salary for women in the finance department, I would use?
Sumifs
Average
Averageifs
Meanifs

Answer 1

To find the mean salary for women in the finance department, you would use the **AVERAGEIFS** function in Excel. This function allows you to calculate the average of a range based on multiple criteria. In your case, you can set criteria for both the gender (women) and the department (finance).

Here’s a basic formula structure for your scenario:

```excel
=AVERAGEIFS(salary_range, gender_range, "Female", department_range, "Finance")
```

- `salary_range`: The range of salaries you want to average.
- `gender_range`: The range containing gender information.
- `"Female"`: The criterion for the gender.
- `department_range`: The range containing department information.
- `"Finance"`: The criterion for the department.

So, **AVERAGEIFS** is the correct choice for your requirement.