"JD" wrote:
It works if there are values in every cell of the column (A2:A7)

Ah, but wasn't that exactly what you showed in your posting?
Take a moment to press the "Yes" button in that response
(like the ones below)

What if some cells do not have values to average?

This should work, array-entered:
=AVERAGE(IF(A2:A7<"",SUBSTITUTE(A2:A7,"<","")+0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---