满足条件行求和

zhangquan19114

在A3中求和滿足7月的G3開始往後的值，即7/3-7/17
在B3中求和滿足8月的G3開始往後的值，即8/2-8/7
以此類推

高个子

1. =SUM((MONTH($G2:$AL2)=A$2)*$G3:$AL3)

复制代码

..

jerrike

1. =SUMPRODUCT((MONTH($G2:$AL2)=A2)*$G3:$AL3)

复制代码

袁勇

=SUM(SUMIF($G$2:$XFD$2,"<="&DATE(2023,A$2+{0,1},0),$G3)*{-1,1})

w4275

1. =NPV(-2,SUMIF($G$2:$AL$2,"<="&EOMONTH(A$2&"-1",{-1,0}),$G3:$AL3))

复制代码

橒♂蝣

=SUM(FILTER($G$3:$AL$3,MONTH($G$2:$AL$2)=A2))

一杯绿茶来了

=SUM(SUMIF($G$2:$AL$2,"<"&EDATE(DATE(2023,A2,1),{0,1}),$G$3:$AL$3)*{-1,1})