[公告](二期)一系4班第六讲9组作业上交专贴

南仁海杨

<p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"><font size="5">9组的同学请来此上交作业<span lang="EN-US">，</span></font></span></strong> </p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><span lang="EN-US" style="FONT-SIZE: 9pt;">&nbsp;<font size="3"><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">作业上交要求：</span></strong></font> <p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><font size="5"><font color="#f70909"><strong><span lang="EN-US" style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">1</span></strong><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">、作业要：参见学委的作业贴里的要求，特别是最后一条</span></strong></font></font><span lang="EN-US" style="FONT-SIZE: 9pt;"><font color="#ff0000" size="5"> </font><p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="5"><strong><span lang="EN-US" style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">2</span></strong><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">、</span></strong><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;">只需要按题序贴出公式。</span></strong></font></p><p><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;"><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"><font color="#ff0000">&nbsp;&nbsp; 前面4个全对的BB分别为：<font size="4">5，4，3，2</font>，其他交了作业不全错的每人<font size="4">1</font>个BB。有效时间参见学委的作业贴</font></span></span></strong></p><p><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;"><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"></span></span></strong><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;">非本组交作业的学员请勿跟贴，否则即删扣分。</span></strong></p>

xiaoni

游客，如果您要查看本帖隐藏内容请回复

</p><p><font color="#ff0000"><strong>注意:公式的通用性</strong></font></p>

[此贴子已经被一剑惊心于2008-10-19 19:45:12编辑过]

xiaoni

游客，如果您要查看本帖隐藏内容请回复

[此贴子已经被一剑惊心于2008-10-19 19:46:21编辑过]

忧蓝

游客，如果您要查看本帖隐藏内容请回复

</p><p>1.=COUNTIF(C3:C21,"a*")</p><p>2.西服</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 业务数=COUNTIF($D$3:$D$22,"西服")&nbsp; </p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 销售量=SUMIF($D$3:$D$22,"休闲服",$G$3:$G$22)</p><p>休闲服&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =COUNTIF($D$3:$D$22,"休闲服")</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =SUMIF($D$3:$D$22,"休闲服",$G$3:$G$22)</p><p>亲子装&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =COUNTIF($D$3:$D$22,"亲子装")</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =SUMIF($D$3:$D$22,"亲子装",$G$3:$G$22)</p><p>运动服&nbsp;&nbsp;&nbsp; =COUNTIF($D$3:$D$22,"运动服")</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =SUMIF($D$3:$D$22,"运动服",$G$3:$G$22)<font color="#0000ff">不觉得第二个参数可以用单元格内容来表示吗？</font></p><p>3.=SUMIF(G3:G22,"&gt;"&amp;LARGE(G3:G22,4))</p><p>4.=SUMIF(B3:B22,"&gt;3",G3:G22)-SUMIF(B3:B22,"&lt;7",G3:G22)<font color="#0000ff">求得不一定是第二季度</font></p><p></p><p>[/hide]</p><p><strong><font color="#ff0000">公式要有通用性</font></strong></p>

[此贴子已经被一剑惊心于2008-10-19 19:48:11编辑过]

一剑惊心

标记

聆听

游客，如果您要查看本帖隐藏内容请回复

</p><p><strong><font color="#ff0000">做题要细心</font></strong></p>

[此贴子已经被一剑惊心于2008-10-21 19:07:19编辑过]

DDCLJ

<p>交作业：</p><p>

游客，如果您要查看本帖隐藏内容请回复

</p><p><strong><font color="#ff0000">不错</font></strong></p><p></p>

[此贴子已经被一剑惊心于2008-10-21 19:09:08编辑过]

yyhangeng

游客，如果您要查看本帖隐藏内容请回复

<font color="#ff0000"><strong>不错</strong></font>

[此贴子已经被一剑惊心于2008-10-21 19:10:25编辑过]

沙漠王子1

游客，如果您要查看本帖隐藏内容请回复

[em03]</p><p><strong><font color="#ff0000">加油</font></strong></p>

[此贴子已经被一剑惊心于2008-10-22 20:11:31编辑过]

与民

<p>

游客，如果您要查看本帖隐藏内容请回复

</p>