總和 指定不含字母 (14367)

E2(只不含B D)=SUM(C:C)-SUM(SUMIF(B:B,"="&{"B","D"},C:C))

E3(表列 可增減){=SUM(C:C)-SUM(SUMIF(B:B,"="&G2:G9,C:C))

E4(只不含B D)=SUMIFS(C:C,B:B,"<>B",B:B,"<>D")