=COUNT(IF(ISNUMBER(A1:A99),A1:A99))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

In xl2007, you should be able to use the whole column. In earlier versions, you
couldn't.

WonderingaboutMicrosoft wrote:

I want to count the cells with numeric values and ignore the cells that
contain #DIV/0! in Office 2007 Beta BTR.

I have tried countif, countifs, and several other formulas. I have tried
setting the cells to TRUE and FALSE and counting numeric values but nothing
seems to work.

Thanks in advance.

--

Dave Peterson