Hi everybody,

I have a column as follows:
12%
0
10%
0
0
5%
The aver. % will be 9%. But, if we take 0 into consideration it will be 4.5%.

How could I the Average formula without taking this 0 into consideration?

Thanks