I am trying to create the following formula
However, it always seems to result in zero, even where a single row would have both values for Tekken and American Football. I have gotten the simpler formula to work...
This formula works fine and counts the rows that have values for Tekken. I am wondering why this works, but the former results in a value of 0. I have rows that have both values and should represent a 1.
Does there have to be special use of AND when dealing with Arrays?