Average with conditions
Average only the values that meet one or more conditions.
The formula
Excel and Google Sheets
=IFERROR(AVERAGEIFS(C2:C100, B2:B100, "Sales"), 0)How it works
AVERAGEIFS(C2:C100, B2:B100, "Sales")Averages the scores in column C for rows where the department is Sales.
IFERROR(…, 0)Shows 0 instead of #DIV/0! when no rows match.
Example
| B: Department | C: Score |
|---|---|
| Sales | 80 |
| Support | 95 |
| Sales | 70 |
Tips
- Result for this data: 75.