Not sure how to put this formula together.

=COUNTIFS(A18:A134,A3,C18:C134,"Yes", (J18:J134,"Yes" or Q18:Q134,"Yes")