Prev: condditional farmulation
Next: Average a column that contains one cell of text
From: Malcolm on 21 May 2010 09:20
What formula can I use to average a column of numbers that has one cell
containing text?
From: RonaldoOneNil on 21 May 2010 09:28
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?
From: Jacob Skaria on 21 May 2010 09:31
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?
 | 
Pages: 1
Prev: condditional farmulation
Next: Average a column that contains one cell of text