What I need it to do is count the number of yes answers in column B if there is a "1" OR "2" in column A.

Any help would be greatly appreciated.

Here is the formula I'm currently using:

=SUMPRODUCT(--(RawData!$A$1:$A$1000="1"),--(RawData!$B$1:$B$1000="Yes"))