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.
