Excel Function: AVERAGEIF

Use AVERAGEIF to return the average of all cells that meet a given criteria

EXAMPLE:

NOTES:

• Cells that contain TRUE or FALSE are ignored
• Empty cells in average_range are ignored
• Empty cell in criteria is treated as 0 value
• Wildcard characters (? - matches any single character) and (* - matches any sequence of characters) can be used