根据每天的数据，求月汇总，和日汇总

yfan17

1. =SUM(SUMIFS($B:$B,$A:$A,DATE(2024,ROW($1:$12),ROW($A1))))

复制代码

1. =NPV(-2,SUMIFS($B:$B,$A:$A,"<="&EOMONTH($H2,{-1,0})))

复制代码

hxj119

=SUM((DAY($A$2:$A$367)=(LEFTB(D2,2)/1))*($B$2:$B$367))
=SUM((MONTH($A$2:$A$367)=MONTH(H2))*($B$2:$B$367))

我的城市你来过

=SUM(IFERROR(FILTER($B$2:$B$367,DAY($A$2:$A$367)=1*REGEXP(D2,"[0-9]+")),0))

wgreen

=SUMPRODUCT((DAY(A$2:A367)&"日"=D2)*B$2:B367)，=SUMPRODUCT((TEXT(A$2:A367,"em")=TEXT(H2,"em"))*B$2:B367)

ggw092

1. =LET(A,SEQUENCE(31),HSTACK(TEXT(A,"#日"),MAP(A,LAMBDA(X,SUM((DAY(A2:A367)=X)*(B2:B367))))))

复制代码

1. =LET(A,SEQUENCE(12),HSTACK(TEXT(A,"#月"),MAP(A,LAMBDA(X,SUM((MONTH(A2:A367)=X)*(B2:B367))))))

复制代码

动态数组