How the AVERAGEIF Function Works
The AVERAGEIF function combines the IF function and AVERAGE function in Excel. This combination allows you to find the average or arithmetic mean of those values in a selected range of data that meets specific criteria.
The IF portion of the function determines what data meets the specified criteria and the AVERAGE part calculates the average or mean.
Normally, AVERAGE IF is used with rows of data called records. In a record, all of the data in each cell in the row is related - such as a company's name, address and phone number.
AVERAGE IF looks for the specific criteria in one cell or field in the record and, if it finds a match, it averages that data or data in another specified field in the same record.
The AVERAGEIF function combines the IF function and AVERAGE function in Excel. This combination allows you to find the average or arithmetic mean of those values in a selected range of data that meets specific criteria.
The IF portion of the function determines what data meets the specified criteria and the AVERAGE part calculates the average or mean.
Normally, AVERAGE IF is used with rows of data called records. In a record, all of the data in each cell in the row is related - such as a company's name, address and phone number.
AVERAGE IF looks for the specific criteria in one cell or field in the record and, if it finds a match, it averages that data or data in another specified field in the same record.