Average a column that contains one cell of text
 

What formula do I use to average a column of numbers that contain one cell
with text? I'm using Excel 2007

Average a column that contains one cell of text
 

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" wrote in message
...
What formula do I use to average a column of numbers that contain one cell
with text? I'm using Excel 2007

Average a column that contains one cell of text
 

=average(c:c) should ignore text. I get 4 from this sample
1
a

1
10


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Malcolm" wrote in message
...
What formula do I use to average a column of numbers that contain one cell
with text? I'm using Excel 2007

Average a column that contains one cell of text
 

=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