Hi,

I'm trying to average a column where 0 is one of the numbers.

However, if the column has three numbers and one is a 0, the numbers are
being averaged by two, not three.

For example. 34 + 0 + 42 =76 and I'm getting a result of 38 when it should
be 25.3.

How do I get Excel to recognize the 0 as an actual number?

Thanks.