Using Countif to count Often and Very Often,

steinkj
✭✭✭✭
however I can't get it to work the Often is also counting the Very Often:
=COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, HAS("Often", @cell), NOT(HAS("Very", @cell)))
Best Answers
-
Hi @steinkj, change the "HAS" to an equal.
=COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, "Often")
-
Thank you, as always I was trying to make it too hard!!!!
Answers
-
Hi @steinkj, change the "HAS" to an equal.
=COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, "Often")
-
Thank you, as always I was trying to make it too hard!!!!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!