Thread: COUNTIF - Not an Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dhstein dhstein is offline
external usenet poster
  
Posts: 266
Default COUNTIF - Not an Error
Is there a way to use Countif to count the number of cells in the range that
are not errors - in other words - they are NOT #VALUE and NOT #DIV 0 etc.

=COUNTIF(A1:A5000, ??????)
Reply With QuoteReply With Quote