=sum(a1:a10)/(count(a1:a10)-countif(a1:a10,0))

markmcd wrote:

Could someone please advise me a nice simple formula for giving an average
for non zero entries. The average function in Excel provides an average of a
list of numbers including numbers that are zero. I need the average of just a
series of numbers where zeros are not considered in the result.

--

Dave Peterson