shikaku https://blog.hatena.ne.jp/shikaku/ shikaku's blog https://blog.systemjp.net/ excel ”＊”＋B1＋”＊”じゃダメ =COUNTIF(A:A,"*"&B1&"*")ネタ元 http://ameblo.jp/sugoikaizen/entry-11484309535.html 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.systemjp.net%2Fentry%2F2013%2F06%2F10%2F110738" title="検索条件をセル参照にして部分一致カウントを行うには”＊”＆B1＆”＊” - shikaku&#39;s blog" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2013-06-10 11:07:38 rich https://blog.systemjp.net/entry/2013/06/10/110738 1.0 100%