Using Countif to count Often and Very Often,

steinkj
steinkj ✭✭✭✭
edited 06/27/23 in Formulas and Functions

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)))

Kim S.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!