Forum Discussion

meirtu's avatar
meirtu
Copper Contributor
Oct 13, 2020
Solved

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

Resources