Hi all

I am trying to work out the average value of Column A1:A500.

What I am needing is a formula that will exclude 0 from the calculations to
give a true average.

Probably an easy one, but cannot seem to locate the correct formula.

Cheers

Patrick