[solved] column avarage %

I need to get an average percentage for the column in the sample. I dont know how to do it with the error cells and the empty cells. I need an average for only the cells with a number in them.
Can anyone help?
thanks in advance

You could use an Array

=AVERAGE(IF(ISNUMBER(D3:D11),D3:D11))
confirmed wtih CTRL + SHIFT + ENTER

In XL2007 you might find you can get away with:

=AVERAGEIF(D3:D11,">0")

Goes without saying that trying to handle underlying errors at source is generally best practice - whenever possible of course.