Do you still want to take into account the column K condition? Try like this

=SUMPRODUCT(('Retailer1!$K$2:$K$2262=CONCATENATE(A5,"LY"))*('Retailer1'!$L$2:$L$2262=0)*('Retailer1!$K$3:$K$2263=CONCATENATE(A5,"LY"))*('Retailer1'!$L$3:$L$2263=1))

Notice that for the third and fourth conditions the ranges need to be "offset" by 1