Excel Function: AVERAGEIFS
Use AVERAGEIFS to return the average of all cells that meet multiple criteria
EXAMPLE:
NOTES:
- If average_range is blank or a text value, AVERAGEIFS returns #DIV0! error
- If a cell in a criteria range is empty, AVERAGEIFS treats it as a 0 value
- Cells in range that contain TRUE evaluate as 1, FALSE evaluate as 0
- Wildcard characters (? - matches any single character) and (* - matches any sequence of characters) can be used