Beast Mode Case Statement Summing multiple rows with multiple conditions

DiLeo

SUM((CASE WHEN `STORE_NUMBER`= 1 AND (YEARWEEK(SUBDATE(`FULL_DATE`, interval 1 day)))=YEARWEEK(CURRENT_DATE())-2 then `ESALES`)) else SUM((CASE WHEN `STORE_NUMBER`= 2 AND (YEARWEEK(SUBDATE(`FULL_DATE`, interval 1 day)))=YEARWEEK(CURRENT_DATE())-2 then `ESALES` END))

This works for the first store when I do that bit alone, but as soon as I add the second part in an else statement it doesn't work. This needs to be done for several stores and ideally I'd do something like this and keep adding else statements.