Try, array-entered (press CTRL+SHIFT+ENTER)
something like:

=AVERAGE(IF(ISNUMBER(A1:A10),A1:A10))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----