求教:筛选后实现自动汇总??

clm03

筛选后怎样实现自动汇总??详细问题见表 NO5cljGt.rar (4.01 KB, 下载次数: 28)

2006-6-12 16:44 上传

点击文件名下载附件
求教:筛选后实现自动汇总??

lyh199

=SUBTOTAL(9,J2:J19)
见附件
wmtuAQ8f.rar (4.39 KB, 下载次数: 57)

2006-6-13 02:32 上传

点击文件名下载附件
求教:筛选后实现自动汇总??

Twice_Shy

<P>=SUBTOTAL(9,J2:J19)</P>
<P>请问这个9是哪里来的，代表什么，谢谢？</P>

lyh199

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>Twice_Shy</i>在2006-6-17 17:00:29的发言：</b><br/><p>=SUBTOTAL(9,J2:J19)</p><p>请问这个9是哪里来的，代表什么，谢谢？</p></div><p><table cellspacing="0" cellpadding="0" width="144" border="0" style="WIDTH: 108pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="2" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="72" height="19" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">1</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent;"><font face="宋体">AVERAGE</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="72" height="19" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">2</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent;"><font face="宋体">COUNT</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="72" height="19" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">3</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent;"><font face="宋体">COUNTA</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="72" height="19" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">4</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent;"><font face="宋体">MAX</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="72" height="19" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">5</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent;"><font face="宋体">MIN</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="72" height="19" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">6</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent;"><font face="宋体">PRODUCT</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="72" height="19" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">7</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent;"><font face="宋体">STDEV</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="72" height="19" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">8</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent;"><font face="宋体">STDEVP</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="72" height="19" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">9</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent;"><font face="宋体">SUM</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="72" height="19" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">10</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent;"><font face="宋体">VAR</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="72" height="19" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">11</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent;"><font face="宋体">VARP</font></td></tr></tbody></table></p>