In that case, you're back with the Sumproduct.

in L9
=SUMPRODUCT(($B$2:$B$12=K9)*($E$2:$G$12="yes"))
copy down

in M9
=SUMPRODUCT(($B$2:$B$12=K9)*((C2:D12="yes")+($H$2:$I$12="yes")))
copy down


cheers,