There are ways to easily do what you want but you should correct your
formulas so that they don't happen.

--
Don Guillett
SalesAid Software

"WonderingaboutMicrosoft"
wrote in message
...
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.