[201401函初班]第二讲作业A组上交帖--开贴

紫金锤

时间过得太快，跟不上了，作业超时，跟帖留脚印吧。

1. =SUM(MOD(ROW(C6:C16)-5,2)*C6:C16)
   
2. =SUMIFS(E22:E30,D22:D30,"古奇",C22:C30,">=40909",C22:C30,"<41275")
   
3. =SUMPRODUCT(($C$36:$C$44=$G42)*($D$36:$D$44=H$41)*($E$36:$E$44))
   
4. =2*ROW(A1)-1
   
5. =MOD(ROW(A3),3)

复制代码

ypf183413821

一、=SUM(C6:C16*(MOD(ROW(C6:C16),2)=0))
二、=SUM((YEAR(C22:C30)=YEAR($C$26))*(D22:D30=$D$26)*E22:E30)
三、=SUMPRODUCT(-($C$36:$C$44=$G42),-($D$36:$D$44=H$41),$E$36:$E$44)
四、=ROW(1:9)*2-1
四、=MOD(ROW(49:57)-1,3)