error if all the cells selected as range fail to meet the criteria, meaning there are no values to average. Excel AverageIF error Specific Range: The function requires a specific range of cells as an argument, an array cannot be substituted instead. Average_range Calculation: The function allo...