View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GoBucks GoBucks is offline
external usenet poster
 
Posts: 3
Default Do Not count iserror cells

Is there a way to do a countif, or counta function and not have the formula
include the cells that return an error when they are blank. If the cell
returns an error it shows #NA, and is not considered blank when i do a counta
function.
--
Jeff