My problem is the exact same as: http://www.excelforum.com/excel-gene...ifs-match.html

This is the answer they came up with: (COUNTIFS($B$14:$B$26,A6,$F$14:$F$26,"Yes")>0)

However, if I type this in, I get the answer FALSE instead of a number...