班门弄斧4:有条件提取数值求和!

小笨蛋 · 发表于 2008-6-28 12:48

J3W7pCag.rar (1.74 KB, 下载次数: 54)

2008-6-28 12:47 上传

点击文件名下载附件
班门弄斧4:有条件提取数值求和! <table cellspacing="0" cellpadding="0" width="604" border="0" xstr="" style="WIDTH: 454pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="150" style="WIDTH: 113pt; mso-width-source: userset; mso-width-alt: 4800;"></col><col width="72" style="WIDTH: 54pt;"></col><col width="382" style="WIDTH: 287pt; mso-width-source: userset; mso-width-alt: 12224;"></col></colgroup><tbody><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" width="150" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 113pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;">a233ds4569a7a5546</td><td class="xl25" align="right" width="72" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">43</td><td class="xl26" width="382" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 287pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">说明:</td></tr><tr height="20" style="HEIGHT: 15pt; mso-height-source: userset;"><td class="xl24" height="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;">a23ds4569a7a5547</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">44</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">在B1:B10输入公式,求第3大后的数字总和</td></tr><tr height="20" style="HEIGHT: 15pt; mso-height-source: userset;"><td class="xl24" height="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;">a23ds4889a7a5548</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">50</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数字排名时重复只算一个,如A1第3大是4!</td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;">a23ds4569a7a5549</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">46</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">A列数字最大不超过99个长度.</td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;">a203ds4569a7a5550</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">46</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">只用函数答题,不能定义名称.</td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;">a23ds477569a7a5551</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">60</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">不能用辅助列,和进行其他设置.</td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;">a23ds477569a7a5552</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">56</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;">a23ds477569a7a5553</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">56</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;">a23ds4a2a4</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">0</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;">a23ds422544a33a5555</td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff;">25</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr></tbody></table>

zhaoxiaofeng · 发表于 2008-6-28 15:55

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

格子布圣诞鹿 · 发表于 2008-6-28 16:08

学习[em04]

小鲤鱼 · 发表于 2008-6-28 18:50

很久没做函数题了，脑袋都锈斗了[em04][em04][em04]

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

willin2000 · 发表于 2008-6-28 23:33

学习了.

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

梦想2008 · 发表于 2008-6-28 23:35

小笨蛋 · 发表于 2008-6-29 13:26

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

luxueyan2008 · 发表于 2008-6-30 13:54

学习

YITIANDENG · 发表于 2008-7-2 07:53

学习

小清风 · 发表于 2008-7-3 12:12

学习

		自动登录	找回密码
密码			注册

[通知] 班门弄斧4:有条件提取数值求和!