Hi,

I have the following formula.
=COUNTIFS(ccs_export!$D:$D,"abc",ccs_export!$AO:$AO,1)+COUNTIFS(ccs_export!$D:$D,"abc",ccs_export!$AS:$AS,1)

Column D, Column AO, Column AS
abc ,1,1
abc ,1,1
cdf ,0,1
cdh ,1,0
abc ,0,0

Is this the correct formula for expressing the following

IF Column D is "abc" and column AO is 1, or Column AS is 1, count 1.?