FormuladrillAverage with two conditions
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Put the average salary for the department in F1 at the office in F2 into F3. Refer to the cells rather than typing the names.
What this exercise teaches
AVERAGEIFS puts the range to average first, like SUMIFS, and divides only by the rows that meet every condition. Picking the wrong office by hand is the mistake it replaces.
A hint if you get stuck
AVERAGEIFS(range to average, range to test, criteria, range to test, criteria).
Try it now, free, no account needed
The first 15 tasks on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro adds timed mode and the certificate.
Open this exerciseMore exercises in Logic and counting
- Pass or failPro
- Letter gradesPro
- Bonus for the northPro
- Count the shipped ordersPro
- Sales for one regionPro
- Two conditions at oncePro
- Flag for reviewPro
- Count with two conditionsPro
- Average for one regionPro
- Scores above a barPro
- Best sale in a regionPro
- Shipping tiersPro
- No more #DIV/0!Pro
- Rank with tiesPro
- Count with a wildcardPro
- Discount rulesPro
- Sales between two datesPro