Just an alternative to the typical AVERAGE array formula:

=SUM(1:1)/SUM(COUNTIF(1:1,{"<","*",0})*{1,-1,-1})

HTH
Jason
Atlanta, GA

-----Original Message-----
How do you average values in a row, ignoring any zeros?
.