excel多区域多列条件求和

2026-05-18 14:03:17
推荐回答(2个)
回答1:

你要的公式:

=SUMIFS(D3:V19,A3:S19,">"&DATEVALUE("2021-6-11"),A3:S19,"<"&DATEVALUE("2021-7-10"))

截图要有行列号,不然公式不好写。格式一致,sumif错位求和即可。

回答2:

公式为:

=SUMIFS(D:V,A:S,">=2021/6/11",A:S,"<=2021/7/10")