Shulou(Shulou.com)06/01 Report--

This article mainly introduces the relevant knowledge of "what is the function of AVERAGEIF function". The editor shows you the operation process through an actual case. The operation method is simple, fast and practical. I hope this article "what is the function of AVERAGEIF function" can help you solve the problem.

Function: returns the arithmetic mean of the parameters that meet the criteria.

Syntax: AVERAGE (range,criteria,average_range)

Description:

The first parameter: range is the conditional region, which is used to determine the range of cells.

The second parameter: Criteria is the condition for finding the average value, which is composed of numbers, logical expressions, etc. Wildcards can be used (including question marks) And asterisk (*).

The third parameter: average_range is the actual average region, which requires the cell, range or reference of the average. When the third parameter is omitted, the conditional region is the actual average region. Find the text, logical value, or empty cell in the average area, ignore it, and calculate the zero value.

Example: to find the average IQ of the Kingdom of Shu: AVERAGEIF ($Dao3ambiguDili11, F3recoveryCentralCentrum 11)

This is the end of the content about "what is the function of AVERAGEIF function". Thank you for your reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.