Prev: Average columns that contain text
Next: How do I get all narrative to fit into one cell block?
From: Malcolm on 21 May 2010 09:26
What formula do I use to average a column of numbers that contain one cell
with text? I'm using Excel 2007
From: T. Valko on 21 May 2010 09:34
The AVERAGE function will ignore text (in an array).

How do you want to handle that one cell with text?

--
Biff
Microsoft Excel MVP


"Malcolm" <Malcolm(a)discussions.microsoft.com> wrote in message
news:A62B59FC-415C-433E-897F-819865239F62(a)microsoft.com...
> What formula do I use to average a column of numbers that contain one cell
> with text? I'm using Excel 2007


From: Don Guillett on 21 May 2010 09:37
=average(c:c) should ignore text. I get 4 from this sample
1
a

1
10


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Malcolm" <Malcolm(a)discussions.microsoft.com> wrote in message
news:A62B59FC-415C-433E-897F-819865239F62(a)microsoft.com...
> What formula do I use to average a column of numbers that contain one cell
> with text? I'm using Excel 2007

From: Gary''s Student on 21 May 2010 09:55
=AVERAGE(A1:A100)
The +AVERAGE() function ignores text values.
--
Gary''s Student - gsnu201003


"Malcolm" wrote:

> What formula do I use to average a column of numbers that contain one cell
> with text? I'm using Excel 2007
 | 
Pages: 1
Prev: Average columns that contain text
Next: How do I get all narrative to fit into one cell block?