Average columns that contain text
 

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

Average columns that contain text
 

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?

Average columns that contain text
 

Do you mean?...

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

--
Jacob (MVP - Excel)


"Malcolm" wrote:

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