Count cells that do not contain specific text and are not blank



I am trying to count all cells that do not contain the text "gap" and cells that are not blank but I'm having trouble. Below are the two formulas I've tried.

=COUNTIF({Range}, NOT(HAS(@cell, "Gap")AND(@cell, <>""))) -> Error: #UNPARSEABLE

=COUNTIF({Range}, NOT(HAS(@cell, "Gap"), NOT(HAS(@cell, <>"")))) -> Error: #INCORRECT ARGUMENT

Any help would be appreciated

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!