Try using IF(ISNA(Counta(.....)),"",counta(......))

"GoBucks" wrote:

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