1、点击E2单元格,输入:=SUM(SUMIF(B2:B7,{">=2021/2/1",">2021/2/3"},C2:C7)*{1,-1}),按ctrl+shift+enter键结束,结果为:710

3、{1440,730}*{1,-1}返回{1440,-730}

时间:2024-10-21 04:13:39
1、点击E2单元格,输入:=SUM(SUMIF(B2:B7,{">=2021/2/1",">2021/2/3"},C2:C7)*{1,-1}),按ctrl+shift+enter键结束,结果为:710
3、{1440,730}*{1,-1}返回{1440,-730}