Like this:

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