Count "Yes" if the Data matches the text

[khateeb]

Can any one advise me, what to do with this formula. Please make it working for me. I cannot find the errors in it. =SUM(SUMPRODUCT(($E$3:$H$14=“yes”)*($I$3:$I$14=B$231)*($E$2:$H$2=$A232)),SUMPRODUCT(($E$24:$H$35=“yes”)*($I$24:$I$35=B$231)*($E$23:$H$23=$A232)),SUMPRODUCT(($S$3:$V$14=“yes”)*($W$3:$W$14=B$231)*($S$2:$V$2=$A232)),SUMPRODUCT(($S$24:$V$35=“yes”)*($W$24:$W$35=B$231)*($S$23:$V$23=$A232)),SUMPRODUCT(($E$44:$H$55=“yes”)*($I$44:$I$55=B$231)*($E$43:$H$43=$A232)),SUMPRODUCT(($S$44:$V$55=“yes”)*($W$44:$W$55=B$231)*($S$43:$V$43=$A232)),SUMPRODUCT(($E$64:$H$75=“yes”)*($I$64:$I$75=B$231)*($E$63:$H$63=$A232)),SUMPRODUCT(($S$64:$V$75=“yes”)*($W$64:$W$75=B$231)*($S$63:$V$63=$A232)),SUMPRODUCT(($E$75:$H$84=“yes”)*($I75:I$84=B$231)*( $E$83:$H$83=$A232)),SUMPRODUCT(($E$104:$H$115=“yes”) *($I$104:$I$115=B$231)*($E$103:$H$103=$A232)),SUMPRODUCT(($S$104:$V$115=“yes”)*( $W$104:$W$115=B$231)*($S$103:$V$103=$A232)),SUMPRODUCT(($E$124:$H$135=“yes”)*($I$124:$I$135=B$231)*($E$123:$H$123=$A232)),SUMPRODUCT(($S$124:$V$141=“yes”)*($W$124:$W$141=B$231)*($S$123:$V$123=$A232)),SUMPRODUCT(($E$151:$H$162=“yes”)*($I$151:$I$162=B$231)*($E$150:$H$150=$A232)),SUMPRODUCT(($S$151:$V$162=“yes”)*($W$151:$W$162=B$231)*($S$150:$V$150=$A232)),SUMPRODUCT(($E$171:$H$182=“yes”)*($I$171:$I$182=B$231)*($E$170:$H$170=$A232)),SUMPRODUCT(($S$171:$V$182=“yes”)*($W$171:$W$182=B$231)*($S$170:$V$170=$A232)),SUMPRODUCT(($E$191:$H$202=“yes”)*($I$192:$I$202=B$231)*($E$190:$H$190=$A232)),SUMPRODUCT(($S$191:$V$202=“yes”)*($W$191:$W$202=B$231)*($S$190:$V$190=$A232)),SUMPRODUCT(($E$211:$H$222=“yes”)*($I$211:$I$222=B$231)*($E$210:$H$210=$A232)))

I want this formula to be working in B232 cell. Please check the attachment