统计 二列包含與不包含數 (9316)

D3=SUMPRODUCT(COUNTIF(F:F,C5:C15)*(COUNTIF(G:G,D5:D15)=0))

另解=COUNT(0/(MMULT(N(COUNTIF(F4:G5,C5:D15)={1,0}),{1;1})=2))

另解=SUM(COUNTIFS(C:C,{"A";"D"},D:D,{"它","他","*"})*{-1,-1,1})