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

Lucas Rayala

Hi @steinkj, change the "HAS" to an equal.

=COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, "Often")

steinkj

Thank you, as always I was trying to make it too hard!!!!

Lucas Rayala

Hi @steinkj, change the "HAS" to an equal.

=COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, "Often")

steinkj

Thank you, as always I was trying to make it too hard!!!!