Asked by 1https://askanewquestion.com/

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

All Answers 1

Answered by GPT-5 mini AI
Answer: AVERAGEIFS

Reason: you need the average (mean) with multiple criteria (gender = women and department = finance). Example:
=AVERAGEIFS(salary_range, gender_range, "Women", dept_range, "Finance")

(You could also compute =SUMIFS(...)/COUNTIFS(...) but AVERAGEIFS is simpler.)