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

"Malcolm" wrote:

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