如何不添加辅助列，按照年和月求和

minstatey

各位大神，求帮忙看看怎么不添加辅助列按照年和月求和。我这边用sumifs之类的已经试了好多次都不行

cutecpu

=sumifs(B:B,A:A,">=2023/2/1",A:A,"<2023/3/1")

ssg365

=SUM((TEXT(Sheet1!A2:A81,"em")-20232=0)*Sheet1!B2:B81)

minstatey

cutecpu 发表于 2023-3-13 20:31
=sumifs(B:B,A:A,">=2023/2/1",A:A,"

这边以后还要一直更新销售数据。这个公式有限制，如果以后数据更新到2023年5月 6月的数据感觉就统计不出来了

juicex

去年截止 =SUMIFS(B:B,A:A,"<"&YEAR(NOW())&"/1/1")
本年上月 =SUMIFS(B:B,A:A,"<"&YEAR(NOW())&"/"&MONTH(NOW())&"/1")
本期发生 =SUMIFS(B:B,A:A,">="&YEAR(NOW())&"/1/1")
截止本月 =SUMIFS(B:B,A:A,"<"&YEAR(NOW()) &"/"& MONTH(NOW())+1 & "/1")
截止本年 =SUMIFS(B:B,A:A,"<="&YEAR(NOW()) &"/12/31")