|
本帖最后由 hcm19522 于 2022-4-30 10:38 编辑
C9:C10=SUMPRODUCT((B$1:Y$1-C$7=0)*B2:Y2)
D9:D10=SUMPRODUCT((B$1:Y$1-C$7<=0)*(B$1:Y$1-EOMONTH(C$7,-MONTH(C$7))+1>=0)*B2:Y2)
E9:E10=SUMPRODUCT((EOMONTH(C$7,-13)+1-B$1:Y$1=0)*B2:Y2)
一式公式 C9:E10=SUMPRODUCT(($B$1:$Y$1-(LEFT($C$7,4)-(COLUMN(A1)=3)&"/"&RIGHT($C$7,2)^(COLUMN(A1)<>2))>=0)*($B$1:$Y$1-(LEFT($C$7,4)-(COLUMN(A1)=3)&"/"&RIGHT($C$7,2))<=0)*$B2:$Y2)
|
|