|
本帖最后由 xuyouxm 于 2014-3-18 11:45 编辑
【2014函数初级班】-C002-xuyouxm
第一题:
不用数组:- =SUM(INDEX(ISODD(ROW(1:11))*C6:C16,,))
复制代码 数组:- =SUMPRODUCT(MOD(ROW(1:11),2)*C6:C16)
复制代码- =SUM(ISODD(ROW(1:11))*C6:C16)
复制代码- =SUM(ISEVEN(ROW(2:12))*C6:C16)
复制代码- =SUM((MOD(ROW(1:11),2)=1)*C6:C16)
复制代码- =SUM(INDEX((MOD(ROW(1:11),2)=1)*C6:C16,,))
复制代码 第二题:- =SUMIFS(E22:E30,D22:D30,D26)
复制代码- =SUMIF(D22:D30,"古奇",E22:E30)
复制代码- =SUM((YEAR(C22:C30)=2012)*(D22:D30=D29)*(E22:E30))
复制代码- =SUMproduct((YEAR(C22:C30)=2012)*(D22:D30=D29)*(E22:E30))
复制代码- =SUMIFS(E22:E30,D22:D30,"古奇",C22:C30,">"&2012)
复制代码 第三题:- =SUMPRODUCT(($C$36:$C$44=$G42)*($D$36:$D$44=H$41),($E$36:$E$44))
复制代码- =SUM(($C$36:$C$44=$G42)*($D$36:$D$44=H$41)*($E$36:$E$44))
复制代码- =SUMIFS($E$36:$E$44,$C$36:$C$44,$G36,$D$36:$D$44,H$35)
复制代码 第四题:- =MOD(ROW(A1),ROW(A2))+ROW(A1)-1
复制代码 |
评分
-
查看全部评分
|