The syntax of the AVERAGEIF function ____ is very similar to the syntax of the SUMIF function.
A) (range,criteria,average_range)
B) (criteria,average,range)
C) (ref,range,criteria)
D) (array,average_range,ref)

Question

Quizplus · Accepted Answer

The correct syntax for the AVERAGEIF function is (range, criteria, [average_range]). This syntax is very similar to the syntax of the SUMIF function, which is (range, criteria, [sum_range]). The only difference is that the AVERAGEIF function calculates the average of the values in the average_range that meet the criteria, while the SUMIF function calculates the sum of the values in the sum_range that meet the criteria.

The Syntax of the AVERAGEIF Function ____ Is Very Similar