How to use excel averageif function

How to use excel averageif function?

1. Meaning of averageif function

Find the average (arithmetic mean) of the cells specified in a certain area that meet the given conditions.

Recommended tutorial: excel tutorial

2. The syntax format of the averageif function

=averageif(range, criteria, [average_range])

=Averageif (condition area, condition, average area)

Parameter Range represents: condition area-the location of the second parameter condition range.

Parameter Criteria means: Condition - is used to define the cells for calculating the average. (The condition can be in the form of a number, expression, cell reference, or text. Used to define the cells for which the average will be calculated. For example, the condition can be the number 10, the expression ">12", the text "Shanghai Shipping Platform" " Or C2.)

Parameter Average_range: Average area - cells involved in calculating the average. (This parameter can be omitted when the condition area and the average area are consistent)

3. Find the average shipment volume of the Shanghai delivery platform as shown in the figure. .

Input formula =AVERAGEIF(A2:A13,C2,D2:D13)

For convenience, I directly use C2 to replace the Shanghai shipping platform. You can also enter the formula =AVERAGEIF(A2:A13,"Shanghai Shipping Platform",D2:D13)

Note that "" should be entered in English.

The above is the detailed content of How to use excel averageif function. For more information, please follow other related articles on the PHP Chinese website!