|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
<DIV class=quote><B>以下是引用<I>tof在2004-3-6 13:03:00</I>的发言:</B><BR><BR><BR> 简单调整,看看是否有用。</DIV><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: ZH-CN; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">谢谢你在论坛上的回复!
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><SPAN lang=EN-US><FONT face="Times New Roman">COUNTIF(INDIRECT($U$2&"!"&"r"&ROW()-2&"c"&"7"&":"&"r"&ROW()-2&"c"&"38",FALSE),"</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">早</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">"),<FONT face=宋体 size=2>请问</FONT><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: ZH-CN; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">公式中的 "r"我不知道是什么意思,我设置的公式反映的计算结果就是</SPAN><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 'Times New Roman'; mso-ascii-font-family: 宋体; mso-ansi-language: ZH-CN; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">“</SPAN><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: ZH-CN; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">#REF!</SPAN><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 'Times New Roman'; mso-ascii-font-family: 宋体; mso-ansi-language: ZH-CN; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">”</SPAN><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: ZH-CN; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">,请告知。</SPAN></FONT></SPAN></FONT>
</SPAN><BR> |
|