Count a Titled Course if there is text in the cell, but not "OTHER"
Sometimes more than 1 course is taught at the same location. I am being asked to count the number of courses taught, quarterly. On rare occasions, a course is not taught and OTHER is entered in that column. (OTHER could mean initial meetings, graduation, etc.)
Here is the existing formula.
=IF([COURSE 2]@row = "OTHER", 0, 1)
And it works great until I get to a row where only one course was taught, so under Course 2, the cell is left blank, so now my formula is lacking a command to not count if the cell is blank. Would this be an IF/AND formula?