AVERAGE
AVERAGE function calculates the average of numbers in the selected range
Syntax
AVERAGE(range)
AVERAGEIF
AVERAGEIF function calculates the average of numbers that satisfies a criteria in the selected range
Syntax
COUNTIF(criteria_range, criteria, [average_range])
- criteria_range: This is the range of cells that you want to apply the criteria to.
- criteria: This is the condition that the cells must meet to be included in the average.
- average_range: This is the range where the function calculated the average.