Excel Practice - AVERAGEIFS
Instruction
Calculate the average of C2:C6 for rows where A2:A6 is "South".
Formula Syntax
=AVERAGEIFS(average_range, criteria_range1, criteria1, ...)
- average_range: Range of numbers to average when criteria are met.
- criteria_range1: Range used to evaluate a condition.
- criteria1: Condition used to filter values.
- ...: Additional optional arguments.
What it does
Average values that match multiple conditions.
sales-by-region.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Region | Rep | Sales |
| 2 | North | Liam | 320 |
| 3 | South | Mia | 280 |
| 4 | North | Noah | 410 |
| 5 | West | Olivia | 295 |
| 6 | South | Paul | 360 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use AVERAGEIFS with clean and consistent ranges for predictable results.
- Validate data types (number, text, date) before applying the formula.
- Test the formula with a small sample first, then scale it to larger ranges.