Lesson 183: How to use the AverageIf function in Excel

The AVERAGEIF function in Excel calculate the average of the eligible cells.

Join the channel Telegram of the AnonyViet 👉 Link 👈

How to use the AverageIf function in Excel 1. For example, the AVERAGEIF function below (two parameters) calculates the average of all values greater than 0 in the range A1:A7.

<img decoding="async" class="aligncenter wp-image-32293 size-full" src="https://anonyviet.com/wp-content/uploads/2021/08/calculate-average-if-greater-than-0.png" alt="Lesson 183: How to use the AverageIf function in Excel" width="604" height="267" srcset="https://anonyviet.com/wp-content/uploads/2021/08/calculate-average-if-greater-than-0.png 604w, https://anonyviet.com/wp-content/uploads/2021/08/calculate-average-if-greater-than-0-300x133.png 300w" sizes="(max-width: 604px) 100vw, 604px" title="Lesson 183: How to use the AverageIf function in Excel 12"/> 2. The AVERAGEIF function below (three parameters, the last parameter is the average range) calculates the average of all values in the range B1:B7 if the corresponding cells are in the range A1:A7 contains Apple.

<img decoding="async" loading="lazy" class="size-full wp-image-32294 aligncenter" src="https://anonyviet.com/wp-content/uploads/2021/08/averageif-with-text-criteria.png" alt="Lesson 183: How to use the AverageIf function in Excel 11" width="604" height="267" srcset="https://anonyviet.com/wp-content/uploads/2021/08/averageif-with-text-criteria.png 604w, https://anonyviet.com/wp-content/uploads/2021/08/averageif-with-text-criteria-300x133.png 300w" sizes="(max-width: 604px) 100vw, 604px" title="Lesson 183: How to use the AverageIf function in Excel 13"/> 3. The AVERAGEIF function below calculates the average of all values in the range B1:B7 if the corresponding cells in the range A1:A7 do not contain Bananas.

<img decoding="async" loading="lazy" class="size-full wp-image-32295 aligncenter" src="https://anonyviet.com/wp-content/uploads/2021/08/calculate-average-if-not-equal-to.png" alt="Lesson 183: How to use the AverageIf function in Excel 12" width="604" height="267" srcset="https://anonyviet.com/wp-content/uploads/2021/08/calculate-average-if-not-equal-to.png 604w, https://anonyviet.com/wp-content/uploads/2021/08/calculate-average-if-not-equal-to-300x133.png 300w" sizes="(max-width: 604px) 100vw, 604px" title="Lesson 183: How to use the AverageIf function in Excel 14"/> 4. The AVERAGEIF function below calculates the average of all values in the range B1:B7 if the corresponding cells in the range A1:A7 contain a zero or more character string + berry. Asterisk

<img decoding="async" loading="lazy" class="size-full wp-image-32296 aligncenter" src="https://anonyviet.com/wp-content/uploads/2021/08/averageif-function-with-asterisk.png" alt="represents a string of zero or more characters." width="604" height="267" srcset="https://anonyviet.com/wp-content/uploads/2021/08/averageif-function-with-asterisk.png 604w, https://anonyviet.com/wp-content/uploads/2021/08/averageif-function-with-asterisk-300x133.png 300w" sizes="(max-width: 604px) 100vw, 604px" title="Lesson 183: How to use the AverageIf function in Excel 13"/> Lesson 183: How to use the AverageIf function in Excel 15

<img decoding="async" loading="lazy" class="size-full wp-image-32297 aligncenter" src="https://anonyviet.com/wp-content/uploads/2021/08/averageif-function-with-question-marks.png" alt="5. The AVERAGEIF function below calculates the average of all values in the range B1:B7 if the corresponding cells in the range A1:A7 contain exactly 4 characters. The question mark (?) represents a character." width="604" height="267" srcset="https://anonyviet.com/wp-content/uploads/2021/08/averageif-function-with-question-marks.png 604w, https://anonyviet.com/wp-content/uploads/2021/08/averageif-function-with-question-marks-300x133.png 300w" sizes="(max-width: 604px) 100vw, 604px" title="Lesson 183: How to use the AverageIf function in Excel 14"/> Lesson 183: How to use the AverageIf function in Excel 16

The AVERAGEIFS function (with an S at the end) in Excel calculates the average value of cells that meet various conditions.

<img decoding="async" loading="lazy" class="size-full wp-image-32298 aligncenter" src="https://anonyviet.com/wp-content/uploads/2021/08/calculate-average-if-between-two-numbers.png" alt="6. The AVERAGEIFS function below calculates the average of all values in the range A1:A7 greater than or equal to 500 and less than or equal to 1000." width="604" height="267" srcset="https://anonyviet.com/wp-content/uploads/2021/08/calculate-average-if-between-two-numbers.png 604w, https://anonyviet.com/wp-content/uploads/2021/08/calculate-average-if-between-two-numbers-300x133.png 300w" sizes="(max-width: 604px) 100vw, 604px" title="Lesson 183: How to use the AverageIf function in Excel 15"/> Lesson 183: How to use the AverageIf function in Excel 17

<img decoding="async" loading="lazy" class="size-full wp-image-32299 aligncenter" src="https://anonyviet.com/wp-content/uploads/2021/08/averageifs-with-text-criteria.png" alt="7. The AVERAGEIFS function below calculates the average of all values in the range C1:C7 if the corresponding cells in the range A1:A7 contain Apple and the corresponding cells in the range B1:B7 contain Red." width="604" height="267" srcset="https://anonyviet.com/wp-content/uploads/2021/08/averageifs-with-text-criteria.png 604w, https://anonyviet.com/wp-content/uploads/2021/08/averageifs-with-text-criteria-300x133.png 300w" sizes="(max-width: 604px) 100vw, 604px" title="Lesson 183: How to use the AverageIf function in Excel 16"/> Lesson 183: How to use the AverageIf function in Excel 18 In addition, you can also view many other excel articles