The table you mentioned on date1 is not the same as any other table on any other sheet?
and you could replace...
=SUM(SUMPRODUCT(($E$3:$H$14="yes")*($I$3:$I$14=B$16)*($E$2:$H$2=E$2)))
with...
=COUNTIFS(E$3:E$14,"yes",$I$3:$I$14,$B16)


It might help if you provided a few sample answers, and explain how you arrived at them?