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