On Wed, 23 Feb 2005 06:29:03 -0800, KIM <KIM@discussions.microsoft.com> wrote:

>I have a column of data as illustrated below than contains numbers, blank
>cells, dashes and < entries. Is it possible to average only the numbers
>ensuring that the divsor is the number of cells that contain number entreis
>rather than all cells containing an entry (eg for below example answer should
>be 0.137)
>
>0.3
>
><0.001
>0.01
>
><0.01
>
>0.1
>
>Thank you

If your entries are in, for example, A1:A8, the formula

=AVERAGE(A1:A8)




--ron