=sum(1:1)/(count(1:1)-countif(1:1,0))

(if you're looking at row 1)

Matt wrote:

How can I get a average of a row without the cells that contain 0?

--

Dave Peterson