EDIT: Correction.

AB2: blank
AC2: blank

AB4: =SUMPRODUCT(($A$4:$A$13=$Z4) * ($B$4:$R$13<0.5) * (MOD(COLUMN($B$3:$R$3)-1,3)=1)) + SUMPRODUCT(('Store 15'!$A$4:$A$13=$Z4) * ('Store 15'!$B$4:$R$13<0.5) * (MOD(COLUMN('Store 15'!$B$3:$R$3)-1,3)=1))
(copy down)

AC4: =SUMPRODUCT(($A$4:$A$13=$Z4) * ($B$4:$R$13>=0.5) * (MOD(COLUMN($B$3:$R$3)-1,3)=1)) + SUMPRODUCT(('Store 15'!$A$4:$A$13=$Z4) * ('Store 15'!$B$4:$R$13>=0.5) * (MOD(COLUMN('Store 15'!$B$3:$R$3)-1,3)=1))
(copy down)