Yes, here's another SUMPRODUCT example to show you how to expand the formula to 4 columns.

=SUMPRODUCT(--(ccs_export!$D2:$D100="abc"), 
       --((   (ccs_export!$AO2:$AO100=1) + (ccs_export!$AQ2:$AQ100=1) + (ccs_export!$AS2:$AS100=1) + (ccs_export!$AY2:$AY100=1)    )>0))