If yes entries in K9:K42 mean that all units in columns C to J in those rows should be deducted from the total in merged cell E1, then

=SUMPRODUCT(C9:J42*(K9:K42<>"yes"))

would be the total of all cells in C9:J42 for which the corresponding cells in K9:K42 are anything other than yes.