excel 单元格内包含A+B(以及仅包含A或B)复制另外指定单元格数值到其他指...答:迟了些还是发了吧!C2=SUMIF(A3,"*收入*",B3)D2=SUMIF(A3,"*支出*",B3)E2=SUMPRODUCT(IF(COUNTIF(A3,"*支出*"),-1,1)*COUNTIF(A3,"*私卡*")*B3)F2=SUMPRODUCT(MIN(IF(COUNTIF(A3,{"*支出*","现金转"}),-1,1))*MAX(COUNTIF(A3,{"*现金*","支出*","收入*"}))*B3...