根据范围设求和公式

hcwja900

根据范围变化进行求和。不知是否能实现

人间油物

=SUMPRODUCT((A2:E2>=--LEFT(F2,4))*(A2:E2<=--RIGHT(F2,4))*A3:E3)

博爱风雨同舟

=SUM(SUMIF(A2:E2,ROW(INDIRECT(SUBSTITUTE(F2,"-",":"))),A3:E3))

jivy1212

1. =SUM(OFFSET(A3,,LEFT(F2,4)-2019,,RIGHT(F2,4)-LEFT(F2,4)+1))

复制代码

1. =NPV(-2,SUMIF(2:2,"<"&MID(F2,{1,6},4)+{0,1},3:3))

复制代码

quqiyuan

1. =SUMIFS($A$3:$E$3,$A$2:$E$2,">="&LEFT($F$2,4),$A$2:$E$2,"<="&RIGHT($F$2,4))

复制代码

hcwja900

jivy1212 发表于 2023-5-25 11:51

谢谢，上面那组公式最适用，可单一列取数，公式列前插新列同样计算