It returns the arithmetic mean (average) of all the cells in a given range that meet a specific criterion. <\/p>\n\n\n\n
The syntax of the function is the following: <\/p>\n\n\n\n
AVERAGEIF<\/strong>(<\/em>range, criterion, [average_range]<\/strong>) <\/p>range<\/strong>: The cells or range of cells we want to calculate the average for, unless the average_range argument is defined. If the optional attribute average_range is defined then range is the range to which we apply the criterion.
criterion<\/strong>: It is the criterion that defines which cells of the range should be included in the calculation of the average.
[average_range]<\/strong>: Optional. The actual set of cells to average. If this argument is omitted the range attribute is used.<\/cite><\/blockquote>\n\n\n\nIf the cells in range are empty or contain logical or text values they are ignored.<\/p>\n\n\n\n
If range is blank the function throws the #DIV\/0! error.<\/p>\n\n\n\n
If no cells meet the criterion the function throws the #DIV\/0! error.<\/p>\n\n\n\n
If a criterion cell is empty, it is treated as a zero.<\/p>\n\n\n\n
You can use the wildcard characters, question mark (?) and asterisk (*), in criteria. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.<\/p>\n\n\n\n
<\/div>\n\n\n\n\n<\/div>\n\n\n\nClick on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n