I am assuming that you are using Excel 2007
try this

=AVERAGEIF(J2:J150,"<""")

for other Excel version, try this

=AVERAGE(IF(J2:J150<"",J2:J150,))

format the cell as h:mm
--
Hope this help

Please click the Yes button below if this post have helped answer your needs

Thank You

cheers, francis





"Chi" wrote:

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