EXCEL COUNT YES PLUS ONE CONDITION

[Unlucky]

I have two columns, AR (Program Name) and BA (Yes or No), and I want to count the number of 'Yes' responses based on the program name. I've tried COUNT, COUNTA, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS, SUMPRODUCT without success. I get returns of 0, all the Yes', and #VALUE. I've been trying to figure this out for over five hours, and Google keeps steering me to =COUNT(A1:A6,"Yes")! Here is the basic formula:

=COUNT('RAW DATA'!$BA$8:$BA$1507,"Yes",'RAW DATA'!$AR$8:$AR$1508=C$102)

The C$102 criteria references the program name.

And yes, I have tried the search parameters in reverse order (AR before BA).

Any help is enormously appreciated!

I really am Unlucky

 

[JamesCanale]

Thank you. I love this stuff. I look forward to retirement when I can do this full-time.