The AVERAGE function will ignore text and blanks

Try this:
=AVERAGE(A1:A10)

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"Andy_Trow" wrote:

I have a range of cells

A1:A10
In each of the cells there can be a number from 1 to 5 or an X
In Cell A12 I want to display the average of all the numbers in A1:A10