Excel AVERAGEIF Function
Syntax
=AVERAGEIF(range; criteria; [average_range])
Description
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
Example Excel File
Enter your email to receive the example Excel file (link valid 24h).
Become a supporter
—
download instantly, no email