Average a column that contains one cell of text

[Malcolm]

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

 

[T. Valko]

The AVERAGE function will ignore text (in an array).

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

 

[Don Guillett]

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

1
10

 

[Gary''s Student]

=AVERAGE(A1:A100)
The +AVERAGE() function ignores text values.