<table cellspacing="0" cellpadding="0" width="702" border="0" xstr="" style="WIDTH: 527pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="702" style="WIDTH: 527pt; mso-width-source: userset; mso-width-alt: 22464;"></col><col></col></colgroup><tbody><tr height="24" style="HEIGHT: 18pt; mso-height-source: userset;"><td class="xl25" width="702" height="24" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 527pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18pt; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font><font class="font8" color="#800000" size="5"><strong>28、SUBTOTAL函数</strong></font></td></tr><tr height="10" style="HEIGHT: 7.5pt; mso-height-source: userset;"><td class="xl24" width="702" height="10" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 527pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 7.5pt; BACKGROUND-COLOR: transparent;"><strong><font color="#800000" size="5"></font></strong></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl25" width="702" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 527pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font size="5"><font face="宋体"> </font><font class="font7"><strong>函数名称:</strong></font><font class="font6">SUBTOTAL</font></font></td></tr><tr height="10" style="HEIGHT: 7.5pt; mso-height-source: userset;"><td class="xl24" width="702" height="10" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 527pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 7.5pt; BACKGROUND-COLOR: transparent;"><font size="5"></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl25" width="702" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 527pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font size="5"><font face="宋体"> </font><font class="font7"><strong>主要功能:</strong></font><font class="font6">返回列表或数据库中的分类汇总。</font></font></td></tr><tr height="10" style="HEIGHT: 7.5pt; mso-height-source: userset;"><td class="xl24" width="702" height="10" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 527pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 7.5pt; BACKGROUND-COLOR: transparent;"><font size="5"></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl25" width="702" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 527pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font size="5"><font face="宋体"> </font><font class="font7"><strong>使用格式:</strong></font><font class="font6">SUBTOTAL(function_num, ref1, ref2, ...)</font></font></td></tr><tr height="10" style="HEIGHT: 7.5pt; mso-height-source: userset;"><td class="xl24" width="702" height="10" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 527pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 7.5pt; BACKGROUND-COLOR: transparent;"><font size="5"></font></td></tr><tr height="58" style="HEIGHT: 43.5pt;"><td class="xl25" width="702" height="58" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 527pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 43.5pt; BACKGROUND-COLOR: transparent;"><font size="5"><font face="宋体"> </font><font class="font7"><strong>参数说明:</strong></font><font class="font6">Function_num为1到11(包含隐藏值)或101到111(忽略隐藏值)之间的数字,用来指定使用什么函数在列表中进行分类汇总计算(如图6);ref1, ref2,……代表要进行分类汇总区域或引用,不超过29个。</font></font></td></tr></tbody></table><table cellspacing="0" cellpadding="0" width="702" border="0" xstr="" style="WIDTH: 527pt; BORDER-COLLAPSE: collapse;"><colgroup><font size="5"><col width="702" style="WIDTH: 527pt; mso-width-source: userset; mso-width-alt: 22464;"></col><col></col></font></colgroup><tbody><tr height="58" style="HEIGHT: 43.5pt;"><td class="xl24" width="702" height="58" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 527pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 43.5pt; BACKGROUND-COLOR: transparent;"><p><font face="宋体" size="5"> <img src="data/attachment/forum/dvbbs/2007-2/200722519203876764.bmp" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" /><br/></font></p><p><font size="5"><font face="宋体"> </font><font class="font7"><strong>应用举例:</strong></font><font class="font6">如图7所示,在B64和C64单元格中分别输入公式:=SUBTOTAL(3,C2:C63)和=SUBTOTAL103,C2:C63),并且将61行隐藏起来,确认后,前者显示为62(包括隐藏的行),后者显示为61,不包括隐藏的行。</font></font></p></td></tr></tbody></table><table cellspacing="0" cellpadding="0" width="702" border="0" xstr="" style="WIDTH: 527pt; BORDER-COLLAPSE: collapse;"><colgroup><font size="5"><col width="702" style="WIDTH: 527pt; mso-width-source: userset; mso-width-alt: 22464;"></col><col></col></font></colgroup><tbody><tr height="46" style="HEIGHT: 34.5pt; mso-height-source: userset;"><td class="xl24" width="702" height="46" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 527pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 34.5pt; BACKGROUND-COLOR: transparent;"><p><font size="5"> <img src="data/attachment/forum/dvbbs/2007-2/200722519222652180.bmp" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" /><br/></font></p><p><font size="5"> <font class="font6"><strong>特别提醒:</strong></font><font class="font5">如果采取自动筛选,无论function_num参数选用什么类型,SUBTOTAL函数忽略任何不包括在筛选结果中的行;SUBTOTAL函数适用于数据列或垂直区域,不适用于数据行或水平区域。</font></font></p></td></tr></tbody></table>
[此贴子已经被作者于2007-2-25 19:36:58编辑过] |