Forum Discussion
meirtu
Oct 13, 2020Copper Contributor
finding the everage from a column of numbers but ignoring the cells in which the value is zero
Hi, How do I find the average of a column of cells, while ignoring the cells in which the value is zero? Let's say 3 out of 6 cells which are under the average formula have a zero value, then I want Excel to average only the other three cells which have a value. just to make it clear: if the column of cells under the formula are: 2, 0, 2, 0, 2, 0 - then the average result should be 2
Thanks in advance
11 Replies
- SergeiBaklanDiamond Contributor
- meirtuCopper Contributor
SergeiBaklanThanks!! this works great!! why should there be a coma before the quotation marks in the formula?
- SergeiBaklanDiamond Contributor
meirtu , you are welcome.
It separates second parameter which defines criteria, please see here AVERAGEIF function