- Picture and text skills
- Case
Returns the average (arithmetic mean) of all cells that satisfy multiple criteria.
Grammar
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
The AVERAGEIFS function syntax has the following parameters:
Average_range: required. One or more cells that contain a number or a name, array, or reference that contains a number to be averaged.
Criteria_range1, criteria_range2, etc.: Criteria_range1 is required, subsequent criteria_range is optional. calculated in
1 to 127 areas of associated criteria.
Criteria1, criteria2, etc.: Criteria1 is required, subsequent criteria are optional. As a number, expression, cell reference, or text
1 to 127 criteria that define the cells for which the average will be calculated. For example, the condition could be expressed as 32, "32", ">32", "apple", or B4.
Description
■ If average_range is null or a text value, AVERAGEIFS returns the #DIV0! error value.
■ If a cell in the criteria range is empty, AVERAGEIFS treats it as a 0 value.
■ Cells in the range that contain TRUE are evaluated as 1; cells in the range that contain FALSE are evaluated as 0 (zero).
■ Each cell in average_range is averaged only if these cells meet all the corresponding conditions specified for it.
■ Unlike the range and condition parameters in the AVERAGEIF function.
Each criteria_range in AVERAGEIFS must be the same size and shape as sum_range.
■ If the cells in average_range cannot be converted to numbers, AVERAGEIFS returns the #DIV0! error value.
■ If there is no cell that meets all conditions, AVERAGEIFS returns the error value #DIV/0!.
■ You can use wildcard characters in criteria, namely question mark (?) and asterisk (*). A question mark matches any single character; an asterisk matches any string of characters.
If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
Note: The AVERAGEIFS function measures central tendency, which is the position of the center of a set of numbers in a statistical distribution.
There are three most commonly used measures of central tendency:
■ Average : The average is the arithmetic mean, calculated by adding a set of numbers and dividing by the number of those numbers.
For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5.
■ Median: The median is the number in the middle of a set of numbers; that is, half the numbers have values greater than the median, and the other half have values smaller than the median.
For example, the median value of 2, 3, 3, 5, 7, and 10 is 4.
■ Mode: The mode is the most frequently occurring number in a set of numbers.
For example, the mode of 2, 3, 3, 5, 7, and 10 is 3.
■ For a symmetrically distributed set of numbers, these three measures of central tendency are the same.
■ These three measures of central tendency may be different for a set of numbers with a skewed distribution.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/AVERAGEIFS-ji-suan-duo-tiao-jian-de-ping-jun-zhi.html
评论列表(196条)
测试