你要的公式:
=SUMIFS(D3:V19,A3:S19,">"&DATEVALUE("2021-6-11"),A3:S19,"<"&DATEVALUE("2021-7-10"))
截图要有行列号,不然公式不好写。格式一致,sumif错位求和即可。
公式为:
=SUMIFS(D:V,A:S,">=2021/6/11",A:S,"<=2021/7/10")