[原创]关于查找某个字符的问题?

rch1980

<h1 style="MARGIN: 0cm 0cm 0pt;"><a name="_Toc55964854"><span style="FONT-SIZE: 10.5pt; LINE-HEIGHT: 240%; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">用</span></a><span style="mso-bookmark: _Toc55964854;"><span lang="EN-US" style="FONT-SIZE: 10.5pt; LINE-HEIGHT: 240%;"><font face="Times New Roman"></font></span></span><span style="mso-bookmark: _Toc55964854;"><span style="FONT-SIZE: 10.5pt; LINE-HEIGHT: 240%; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">什么来计算整个</span></span><span style="mso-bookmark: _Toc55964854;"><span lang="EN-US" style="FONT-SIZE: 10.5pt; LINE-HEIGHT: 240%;"><font face="Times New Roman">B</font></span></span><span style="mso-bookmark: _Toc55964854;"><span style="FONT-SIZE: 10.5pt; LINE-HEIGHT: 240%; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">列中含有“</span></span><span style="mso-bookmark: _Toc55964854;"><span lang="EN-US" style="FONT-SIZE: 10.5pt; LINE-HEIGHT: 240%;"><font face="Times New Roman">F</font></span></span><span style="mso-bookmark: _Toc55964854;"><span style="FONT-SIZE: 10.5pt; LINE-HEIGHT: 240%; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">”这个字符的单元格的个数?</span></span><span style="mso-bookmark: _Toc55964854;"></span><span lang="EN-US" style="FONT-SIZE: 10.5pt; LINE-HEIGHT: 240%;"><p></p></span></h1>

hai

COUNTIF(B:B,"*F*")

大致若汝

=COUNTIF(B:B,"F")