发布网友 发布时间:2022-07-26 17:24
共4个回答
热心网友 时间:2023-10-21 16:38
=SUM((A:A)*IF(B:B="C",1,-1))热心网友 时间:2023-10-21 16:39
=SUM(IF(B1:B13="C",-1,1)*A1:A13)热心网友 时间:2023-10-21 16:39
=if(b1="c",a1*-1,if(b1="d",a1*1,0))热心网友 时间:2023-10-21 16:40
=SUMIF(B1:B15,"D",A1:A15)-SUMIF(B1:B15,"C",A1:A15)