The AVERAGEIF function

Share on facebook
Share on twitter
Share on linkedin
Share on telegram
Share on whatsapp

Contents

The AVERAGEIF function

Returns the average (arithmetic average) of all cells in a range that meet a certain criteria. Is the like “average” of SUMIF.

The AVERAGE YES The function measures what is known as “central tendency”, which is the location of the center of a group of numbers in a statistical distribution. There are three common measures of central tendency:

  • Average: the arithmetic mean, calculated by adding a group of numbers and then dividing by the count of those numbers. As an example, the average of 2, 3, 3, 5, 7 Y 10 it is 30 divided by 6, What is it 5
  • Median: the middle number of a group of numbers; In other words, half of the numbers have values ​​greater than the median and half of the numbers have values ​​less than the median. As an example, the median of 2, 3, 3, 5, 7 Y 10 it is 4. If the number of values ​​in the selection is an even number, the median is set as the midpoint between the two middle numbers.
  • Way: the most frequently occurring number in a group of numbers. As an example, the fashion of 2, 3, 3, 5, 7 Y 10 it is 3.

For a symmetric distribution of a group of numbers, these three measures of central tendency are all the same. For a skewed distribution of a group of numbers, they can be different.

The AVERAGE YES The function uses the following syntax to operate:

AVERAGE YES (rank, criterion, [average_range])

The AVERAGE YES The function has the following arguments:

  • encompass: This is required. One or more cells to use for the criteria, including numbers, Names, arrays or references containing numbers.
  • criterion: this is also necessary. The criterion in the form of a number, expression, cell or text reference that sets which cells are averaged. As an example, the criteria can be expressed as 32, “32”, “> 32”, “apples”, B4 O “> =” &B4.
  • average range: Optional. The actual set of cells to average. If omitted, range is used. Despite this, be careful: and a average range it is specified that it does not have the same dimensions as encompass, the average range will be modified using the upper left cell specified in the range, but then use the dimensions that correspond in size and shape to encompass, p.ej
Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.