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

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

=average(a1:a10)
will ignore text

And return 0 if there are no numbers in A1:A10.

Maybe you could use:

=if(count(a1:a10)=0,"No Numbers",average(a1:a10))

to avoid seeing the 0's.



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

--

Dave Peterson

Oops.

If there are no numbers in the range, then =average() will return an error
(#Div/0!)

Dave Peterson wrote:

=average(a1:a10)
will ignore text

And return 0 if there are no numbers in A1:A10.

Maybe you could use:

=if(count(a1:a10)=0,"No Numbers",average(a1:a10))

to avoid seeing the 0's.

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

--

Dave Peterson

--

Dave Peterson