发布网友 发布时间:2022-04-23 01:47
共1个回答
热心网友 时间:2023-07-29 14:02
什么意思?自问自答?
=SUMIFS(E2:E21,B2:B21,"ipad",C2:C21,"西安",A2:A21,2013)+SUMIFS(E2:E21,B2:B21,"ipad",C2:C21,"西安",A2:A21,2012)
或
=SUM(SUMIFS(E2:E21,B2:B21,"ipad",C2:C21,"西安",A2:A21,{2012,2013}))
这样试一下