=SUM(A:A)/COUNTIF(A:A,"<0")

Vaya con Dios,
Chuck, CABGx3


"Mark" wrote in message
...
How do you average values in a row, ignoring any zeros?