Average
Thank you!
"Francis" wrote:
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
|