=SUMIF(J2:J150,"<0")/COUNTIF(J2:J150,"<0")

Format as desired.

--
Best Regards,

Luke M
"Chi" wrote in message
...
Hi,

I would like to average hours (h:mm format) on column J from cell 2 to
cell
150
My formula for Average is =Average IF (J2:J150), "<0", but the result is
wrong.

Since there are many cells don't have any value yet, I would like to
average
the cells have values only.

Thanks
Chi