Our students have completed a form in which they expressed their preferences for fall classes. This data is stored in the [IntentToReturn] table. I am attempting to create a second table that will count the number of students in this table that meet certain conditions. For example, students who prefer both an online class and a morning class.
Here is template formula I am trying to apply:
Here is the table I created:
And here is the formula for one of the columns. All the columns have a similar formula:
There are no error messages, but the table that contains these formulas shows up as completely blank:
Any help or advice you can offer would be greatly appreciated.