|
<div style="LINE-HEIGHT: 22px; HEIGHT: 22px;"><div style="FLOAT: left;"><img alt="发贴心情" src="http://www.excelpx.com/skins/Default/topicface/face1.gif"/></div><b>第六讲作业答案</b></div><div style="MARGIN-TOP: 10px; FONT-SIZE: 9pt; MIN-HEIGHT: 200px; WORD-BREAK: break-all; TEXT-INDENT: 24px; LINE-HEIGHT: normal; WORD-WRAP: break-word;"><hr noshade="true" size="1"/><font color="#808080">以下内容只有<b>回复</b>后才可以浏览</font><br/><p>1,=COUNTIF(C11:C22,">100")</p><p>2,=SUMIF($B$11:$B$22,"一车间",$C$11:$C$22)+SUMIF($B$11:$B$22,"一车间",$D$11:$D$22)+SUMIF($B$11:$B$22,"一车间",$E$11:$E$22)</p><p>3,=IF(AND($C16:$E16>100),"达标","未达标") 数组</p><p>4,逗号表示换列,分号表示换行;此数组表示一个3行3列的数据区域.</p><p>5,=SUM(--($C$11:$C$22>100)) 数组</p><p> =SUM(($B$11:$B$22="一车间")*$C$11:$E$22) 数组</p></div> |
|