Calculating the average

[Guest]

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

 

[Guest]

The AVERAGE function will ignore text and blanks

Try this:
=AVERAGE(A1:A10)

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

XL2003, WinXP

 

[Dave Peterson]

=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.

 

[Dave Peterson]

Oops.

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