=SUMIF(A1:A44,"<0")/COUNTIF(A1:A44,"<0")

Vaya con Dios,
Chuck, CABGx3


"PA" wrote in message
...
I recall reading this and now cant find it.
A column of data with numerical values, some empty cells and some with
zero's.
I need to calculate the average, but supress cells with zeros from the
calculation.

I tried =IF((A1:A44)<0,AVERAGE(A1:A44)) arrayed entered, but no go.

Suggestions welcomed, and my thanks.
Paul