Hi,

Please let me know if there is a formula that allows me to do the following:

A1 A2
AVG: 5
0 5
3
0 2
7
5
0 1

I just want the average to reflect the average of the numbers in column A2
where column A1 does not have a zero.

Thanks