发布网友 发布时间:2022-03-07 17:14
共4个回答
热心网友 时间:2022-03-07 18:43
=SUMIF(C1:C4,"",B1:B4)热心网友 时间:2022-03-07 20:01
=SUMPRODUCT((C1:C100="空")*B1:B100)热心网友 时间:2022-03-07 21:36
=sumif(C1:C4,"空",B1:B4)热心网友 时间:2022-03-07 23:27
=if(c1="",sum($b$1:$b1),) 向下填充就好了