Hi

One way would be the following Array entered formula
{=SUM(IF(ISNUMBER(A1:A13),A1:A13,0))/COUNT(A1:A13)}

Use Ctrl+Shift+Enter to commit or Edit the formula
Do not type the curly braces { } yourself, Excel will enter them for
you if you use Ctrl+Shift+Enter

--
Regards

Roger Govier


"JRD" wrote in message
...
Can anyone tell me whether there is a way to average a whole column of
numbers but ignoring blank cells or cells with errors in

e.g.

Column A

1
2
4
5
3
5
4
DIV0!
DIV0!
3
4
blank
2

Many thanks

John