<table cellspacing="0" cellpadding="0" width="658" border="0" xstr="" style="WIDTH: 494pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="658" style="WIDTH: 494pt; mso-width-source: userset; mso-width-alt: 21056;"></col><col></col></colgroup><tbody><tr height="24" style="HEIGHT: 18pt; mso-height-source: userset;"><td class="xl25" width="658" height="24" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 494pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 18pt; BACKGROUND-COLOR: transparent;"><strong><font color="#800000" size="5">10、DCOUNT函数</font></strong></td></tr><tr height="13" style="HEIGHT: 9.75pt; mso-height-source: userset;"><td class="xl24" width="658" height="13" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 494pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 9.75pt; BACKGROUND-COLOR: transparent;"><strong><font color="#800000" size="5"></font></strong></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl26" width="658" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 494pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font size="5"> <font class="font6"><strong>函数名称:</strong></font><font class="font5">DCOUNT</font></font></td></tr><tr height="13" style="HEIGHT: 9.75pt; mso-height-source: userset;"><td class="xl24" width="658" height="13" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 494pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 9.75pt; BACKGROUND-COLOR: transparent;"><font size="5"></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl26" width="658" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 494pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font size="5"> <font class="font6"><strong>主要功能:</strong></font><font class="font5">返回数据库或列表的列中满足指定条件并且包含数字的单元格数目。</font></font></td></tr><tr height="13" style="HEIGHT: 9.75pt; mso-height-source: userset;"><td class="xl24" width="658" height="13" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 494pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 9.75pt; BACKGROUND-COLOR: transparent;"><font size="5"></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl26" width="658" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 494pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font size="5"> <font class="font6"><strong>使用格式:</strong></font><font class="font5">DCOUNT(database,field,criteria)</font></font></td></tr><tr height="13" style="HEIGHT: 9.75pt; mso-height-source: userset;"><td class="xl24" width="658" height="13" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 494pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 9.75pt; BACKGROUND-COLOR: transparent;"><font size="5"></font></td></tr><tr height="39" style="HEIGHT: 29.25pt;"><td class="xl26" width="658" height="39" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 494pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 29.25pt; BACKGROUND-COLOR: transparent;"><font size="5"> <font class="font6"><strong>参数说明:</strong></font><font class="font5">Database表示需要统计的单元格区域;Field表示函数所使用的数据列(在第一行必须要有标志项);Criteria包含条件的单元格区域。</font></font></td></tr><tr height="13" style="HEIGHT: 9.75pt; mso-height-source: userset;"><td class="xl24" width="658" height="13" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 494pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 9.75pt; BACKGROUND-COLOR: transparent;"><font size="5"></font></td></tr><tr height="39" style="HEIGHT: 29.25pt;"><td class="xl26" width="658" height="39" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 494pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 29.25pt; BACKGROUND-COLOR: transparent;"><font size="5"> <font class="font6"><strong>应用举例:</strong></font><font class="font5">如图1所示,在F4单元格中输入公式:=DCOUNT(A1:D11,"语文",F1:G2),确认后即可求出“语文”列中,成绩大于等于70,而小于80的数值单元格数目(相当于分数段人数)。</font></font></td></tr></tbody></table><p><img src="data/attachment/forum/dvbbs/2007-2/200722518444556199.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="" /></p><p><table cellspacing="0" cellpadding="0" width="658" border="0" xstr="" style="WIDTH: 494pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="658" style="WIDTH: 494pt; mso-width-source: userset; mso-width-alt: 21056;"></col></colgroup><tbody><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl24" width="658" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 494pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"> <font size="5"><font class="font6"><strong>特别提醒:</strong></font><font class="font5">如果将上述公式修改为:=DCOUNT(A1:D11,,F1:G2),也可以达到相同目的。</font></font></td></tr></tbody></table></p><br/>
[此贴子已经被作者于2007-2-25 18:45:21编辑过] |