=AVERAGE(IF(ISNUMBER(A1:A10)*(A1:A10=0),A1:A10))

Jerry

Ragdyer wrote:

Dave,

Those formulas don't seem to work right if there are blank (MT) cells in the
range!