CountIF for whole column Not just a range of rows
I'm trying to count the numbers of "text a" appears in an entire column.
This is the formulas I'm working with, that both produces an unparseable error are:
=COUNTIF(contains("Resident Instruction", [Resident or World Campus Offering]))
=COUNTIF([Resident or World Campus Offering], ="Resident Instruction")
What am I doing wrong?
Help Article Resources
Check out the Formula Handbook template!