Thread: Count cells with numbers and ignore cells with errors
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
PapaDos PapaDos is offline
external usenet poster
  
Posts: 208
Default Count cells with numbers and ignore cells with errors
=COUNT( your_range )
???

--
Regards,
Luc.

"Festina Lente"


"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.
Reply With QuoteReply With Quote