Small update to my previous formula, adds the VALUE() function to convert
numbers stored as text to numerical values, still entered CTRL+SHIFT+ENTER:

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


--
Regards,
Dave


"David Billigmeier" wrote:

Try this. I assumed your range was A1:A10, change this to fit your data.
Enter this formula by using CTRL+SHIFT+ENTER as it is an array formula:

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


--
Regards,
Dave


"KhaVu" wrote:

I used AVERAGE function in my spreasheet and received #DIV/0! error from it.
Is there a safe proof way to omit the invalid values out of the average
calculation.