Tweet
The AVERAGEIF Function's Arguments
The function's arguments tell the function what condition is being tested for and what range of data to average when that condition is met.
Range - the group of cells the function is to search.
Criteria - this value is compared with the data in the Range. If a match is found then the corresponding data in the Average_range is averaged. Actual data or the cell reference to the data can be entered for this argument.
Average_range (optional) - the data in this range of cells is averaged when matches are found between the Range and Criteria arguments. If the Average_range argument is omitted, the data matched in the Range argument is averaged instead.
The function's arguments tell the function what condition is being tested for and what range of data to average when that condition is met.
Range - the group of cells the function is to search.
Criteria - this value is compared with the data in the Range. If a match is found then the corresponding data in the Average_range is averaged. Actual data or the cell reference to the data can be entered for this argument.
Average_range (optional) - the data in this range of cells is averaged when matches are found between the Range and Criteria arguments. If the Average_range argument is omitted, the data matched in the Range argument is averaged instead.