统计公式

lqyqing

问题如附件

无关岁月

1. =NPV(-2,SUMIF(A:A,"<="&EOMONTH(G2,{-1,0}),B:B))

复制代码

1. =NPV(-2,SUMIF(A:A,"<="&EOMONTH(G4&"12月",{-12,0}),B:B))

复制代码

博爱风雨同舟

=SUM(MAP($A$2:$A$208,LAMBDA(x,MEDIAN(EOMONTH(G2,{0,-1})+{0,1},x)=x))*$B$2:$B$208)

博爱风雨同舟

=SUM((1-ISERR(VDB(,,EOMONTH(G2,0),EOMONTH(G2,-1)+1,$A$2:$A$208)))*$B$2:$B$208)

忙到飞起

=SUM(FILTER($B$2:$B$208,ISNUMBER(FIND(TEXT(SUBSTITUTE(G2,"年","/"),"e/mm"),TEXT($A$2:$A$208,"e/mm")))))
写的不好