Count a Titled Course if there is text in the cell, but not "OTHER"

Kitty
Kitty ✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

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? 

Formula to count courses with exception of OTHER.JPG

Tags:

Comments