Google表格会统计一个特定字词中有多少个单元格? [英] Google Sheets count how many cells contain a specific word / words?

问题描述

我正在尝试查看一组列/单元格中的所有单元格，以计算其中有多少个单词包含WORDHERE(在此示例中)

I'm trying to look at all cells in a set of columns/cells to count how many of them contain the word WORDHERE (in this example)

我尝试使用:

=SUM(COUNTIF(A1:A100, "WORDHERE"))

但是，由于该单元格包含其他单词/字母/数字，因此找到0，如果该单元格仅包含WORDHERE，则效果很好.

However this finds 0 as the cell contains other words/letters/numbers, if the cell only contains WORDHERE it works perfectly.

我尝试使用几种regeexxtract和regexmatch，包括您在下面看到的实际单词:

I've tried using several regeexxtract and regexmatch including the actual word as you can see below:

=SUM(COUNTIF(A1:A100,REGEXEXTRACT(A1:A100, "WORDHERE")))

但是，它仍然找到0个匹配项.

But again, it finds 0 matches.

我在做什么错了?

推荐答案

不是完全回答您所做的错误，但是您可以执行以下操作:

Not exactly answering what you are doing wrong, but here is what you can do:

=COUNTIF(A1:A100, "*WORDHERE*")

这篇关于Google表格会统计一个特定字词中有多少个单元格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！