It will only average the cells with numbers. Make sure the blank cells ARE
blank.

--
Ken Russell


Remove yourhat to reply by e-mail
..

"Randy Lefferts" wrote in message
...
I have a column with 31 rows. In select cells, there is
a number. I want to average the numbers. How do I
average only the cells that contain data, ignoring blank
cells? Thanks!

Excel 2003