[求助]请教统计数据的函数，谢谢详见附件

jf530qy

XKDyA3FW.rar (7.47 KB, 下载次数: 23)

2008-2-21 13:00 上传

点击文件名下载附件
[求助]请教统计数据的函数，谢谢详见附件

<br/>

yoka

g4=SUMPRODUCT((本月奖惩登记表!$C$3:$C$16=$C4)*(本月奖惩登记表!$H$3:$H$16=G$2)*本月奖惩登记表!$I$3:$I$16)&nbsp; 右拉下拉

kowloon

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN;"><font face="Times New Roman">G4=IF(B4="","",SUMPRODUCT((</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-fareast-language: ZH-CN; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">本月奖惩登记表</span><span lang="EN-US" style="mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN;"><font face="Times New Roman">!$B$3:$B$16=$B4)*(</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-fareast-language: ZH-CN; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">本月奖惩登记表</span><span lang="EN-US" style="mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN;"><font face="Times New Roman">!$H$3:$H$16="</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-fareast-language: ZH-CN; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">奖励</span><span lang="EN-US" style="mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN;"><font face="Times New Roman">"),</font></span><span lang="ZH-CN" style="FONT-FAMILY: SimSun; mso-fareast-language: ZH-CN; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">本月奖惩登记表</span><span lang="EN-US" style="mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN;"><font face="Times New Roman">!$I$3:$I$16))</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">&nbsp;<p></p></font></span></p><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: &quot;Times New Roman&quot;; mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">H4=IF(B4="","",SUMPRODUCT((</span><span lang="ZH-CN" style="FONT-SIZE: 12pt; FONT-FAMILY: SimSun; mso-fareast-language: ZH-CN; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-family: &quot;Times New Roman&quot;;">本月奖惩登记表</span><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: &quot;Times New Roman&quot;; mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">!$B$3:$B$16=$B4)*(</span><span lang="ZH-CN" style="FONT-SIZE: 12pt; FONT-FAMILY: SimSun; mso-fareast-language: ZH-CN; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-family: &quot;Times New Roman&quot;;">本月奖惩登记表</span><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: &quot;Times New Roman&quot;; mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">!$H$3:$H$16="</span><span lang="ZH-CN" style="FONT-SIZE: 12pt; FONT-FAMILY: SimSun; mso-fareast-language: ZH-CN; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-family: &quot;Times New Roman&quot;;">惩处</span><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: &quot;Times New Roman&quot;; mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">"),</span><span lang="ZH-CN" style="FONT-SIZE: 12pt; FONT-FAMILY: SimSun; mso-fareast-language: ZH-CN; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-family: &quot;Times New Roman&quot;;">本月奖惩登记表</span><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: &quot;Times New Roman&quot;; mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA;">!$I$3:$I$16))</span>

jf530qy

<p>谢谢2位朋友给的支持</p><p></p>