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

This article mainly introduces "what is the function of the AVERAGEIFS function". In the daily operation, I believe that many people have doubts about the function of the AVERAGEIFS function. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "what is the function of the AVERAGEIFS function?" Next, please follow the editor to study!

Function: returns the arithmetic mean of parameters that meet multiple conditions.

Syntax: AVERAGE (average_range,range1,criteria1,range2,criteria2,.)

Description:

The first parameter: average_range is the actual average region, which requires the cell, range or reference of the average. Text, logical value, or empty cell in the evaluation area, ignored, zero calculated.

The second set of parameters: range1 is the conditional region, which is used for the cell range of the first conditional judgment. Criteria1 is the first 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 set of parameters: range2 is the conditional region, which is used for the second conditional range. Criteria2 is the second condition for finding the average value. Others are the same.

Example: to find the average IQ of Shu with an IQ higher than 80: AVERAGEIFS ($Cure 3, Vol. 11, D, F, F, C, Q, Q

At this point, the study of "what is the function of the AVERAGEIFS function" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.