用SUMIFS对相对应日期内求和
我用=SUMIFS(D:D,A:A,">=2021/8/2",A:A,"<=2021/8/8")对8月2日到8月8日的数量进行求和为啥求出来是零
=SUMIFS(D:D,A:A,">="&DATE(2021,8,2),A:A,"<="&DATE(2021,8,8))
热门标签:
我用=SUMIFS(D:D,A:A,">=2021/8/2",A:A,"<=2021/8/8")对8月2日到8月8日的数量进行求和为啥求出来是零
=SUMIFS(D:D,A:A,">="&DATE(2021,8,2),A:A,"<="&DATE(2021,8,8))