|
E17:yuhuisjeng
第一题
0102- {=SUM(B15:B19*1)};{=SUM(--(B15:B19))}
复制代码 03- {=SUM(--(ISTEXT(B23:B27)))};{=SUM(ISTEXT(B23:B27)*1)};=COUNTIF(B23:B27,"*")
复制代码 04- =SUM(IF(C32:C37="男",1,""))
- =SUM(IF(C32:C37="女",1,""))
复制代码 05- {=SUM((B41:B46="一组")*(D41:D46="男"))}
- {=SUM((B41:B46="二组")*(D41:D46="女"))}
复制代码 06- {=SUM((B50:B55="一组")*(C50:C55>3)*D50:D55)};=SUMIFS(D50:D55,B50:B55,"一组",C50:C55,">3")
复制代码 07- {=SUM((B59:B64="一组")*(D59:D64>30)*D59:D64)};=SUMIFS(D59:D64,B59:B64,"一组",D59:D64,">30")
- {=SUM((B59:B64="二组")*(D59:D64>30)*D59:D64)};
- =SUMIFS(D59:D64,B59:B64,"二组",D59:D64,">30")
复制代码 0809- =SUM(B71:B73,D71:D74);=SUM(B71:D74)
复制代码 10第二题
01- =SUMIFS(F88:F103,E88:E103,">80",F88:F103,">=3000",F88:F103,"<=5000")
复制代码 0203- =SUMIFS(D116:D121,C116:C121,"男",D116:D121,">80")
复制代码 04- =SUMIF(B125:B133,"手机",D125:D133)+SUMIF(B125:B133,"彩电",D125:D133)
复制代码 05- =SUMIFS(D137:D145,D137:D145,">5",D137:D145,"<7")
复制代码 06- =SUMIF(B149:B158,"A*",C149:C158)
复制代码 07- =SUMIF(B162:B171,"*A",C162:C171)
复制代码 08- =SUMIF(B175:B184,"A*A",C175:C184)
复制代码 09- =SUMIFS(F188:F203,E188:E203,80,F188:F203,">=3000",F188:F203,"<=5000")
复制代码 10- =SUMIFS(F208:F223,D208:D223,"?1",E208:E223,">80",F208:F223,">=3000",F208:F223,"<=5000")
复制代码 第三题
01- =SUMPRODUCT((E227:E242>80)*(F227:F242>=3000)*(F227:F242<=5000)*F227:F242);=SUM((E227:E242>80)*(F227:F242>=3000)*(F227:F242<=5000)*F227:F242)
复制代码 02- =SUMPRODUCT((C248:C259="男")*D246:D257)
复制代码 03- =SUMPRODUCT((C265:C276="男")*(D263:D274>450)*D263:D274)
复制代码 04- =SUMPRODUCT((C282:C293="男")*(D280:D291>450));=SUMPRODUCT((C282:C293="男")*1,(D280:D291>450)*1)
复制代码 05- =SUMPRODUCT((MOD(ROW(B296:D304),2)=1)*B296:D304)
复制代码 06- =SUMPRODUCT((MOD(COLUMN(B307:D315),2)=1)*B307:D315)
复制代码 07- =SUMPRODUCT((MOD(COLUMN(B318:D326),2)=1)*(MOD(B318:D326,4)=0)*B318:D326)
复制代码 08- =SUMPRODUCT((MOD(ROW(B329:D337),2)=0)*(MOD(B329:D337,4)=0)*B329:D337)
复制代码 09- =SUMPRODUCT((MOD(B340:D348,4)=0)*B340:D348)
复制代码 10- =SUMPRODUCT((MOD(B351:D359,10)=0)*B351:D359)
复制代码 附加题
01- =SUMPRODUCT((RANK(B363:B371,B363:B371)<=3)*B363:B371)
复制代码 02回答完毕。
|
评分
-
查看全部评分
|