Excel Function : AVERAGEIFS

Download now!

Excel Function : AVERAGEIFS

Category

Statistical

Description

Returns the average (arithmetic mean) of all cells that meet multiple criteria.

Microsoft Excel Reference Page

https://support.office.com/en-us/article/AVERAGEIFS-function-48910c45-1fc0-4389-a028-f7c5c3001690

Syntax and Description of the AVERAGEIFS Excel Function

I want to get the average of values in one column if the value in corresponding column is greater than 0. | A | B | C | 1 | 1 | 0 | 1 | 2 | 2 | 0 | 2 | 3 | 3 | 0 | 3 | 4 | 4 | 0 | 4 | 5 | 5 | 0 | 5 | 6 | 6 | 0 | 6 | 7 | 7 | 0 | 7 | 8 |

About AVERAGEIFS Excel Function

The AVERAGEIFS function returns the average (arithmetic mean) of all numbers in a range that meet multiple criteria. AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) average_range - The range of cells to average. criteria_range1 - The first range in which to evaluate the associated criteria. criteria1 - The criteria in the form of a number, date, or text that defines which cells in criteria_range1 will be used in the calculation. criteria_range2, criteria2, ... - [Optional] Additional ranges and criteria to consider.