Hello --

I am trying to count the number of times the below text shows up in a column. I'd like to keep it simple, so no adding adding the Countif formulas.

My current formula is below:
=COUNTIF(DATA!$AQ:$AQ,{"DOCTORAL";"MASTERS";"NULL/ND"})

It is only counting Doctoral, not Masters or NULL/ND.

Thanks.