Average columns that contain text

[Malcolm]

What formula can I use to average a column of numbers that has one cell
containing text?

 

[RonaldoOneNil]

You haven't said whether you want the text to be ignored or used in the
average as if the cell was 0 ?

if the following is in A1 to A6 then =AVERAGE(A1:A6) gives 7. Is this what
you want ?
10
12
8
4
Hello
1

 

[Jacob Skaria]

Do you mean?...

=SUM(A:A)/COUNTA(A:A)