计算 A 列中包含“(CLOSED)"的所有行或“(请勿使用)" [英] Count all rows in column A containing "(CLOSED)" or "(DO NOT USE)"

问题描述

我试图通过 Excel 函数返回 A 列中包含文本 (CLOSED) 或 (DO NOT USE) 的所有行的计数.所有行也将包含其他值，如下所示:

I am trying to return by Excel function a count of all the rows in column A where the text (CLOSED) or (DO NOT USE) is contained. All rows will contain other values too like so:

Row 1 = Nice Day (CLOSED)
Row 2 = Hello (CLOSED)
Row 3 = Cats & DOGS (CLOSED)
Row 4 = Cats (DO NOT USE)

所以我需要在文本中搜索关键字 (closed) 或 (do not use) .

so I need to search for the keywords (closed) or (do not use) in amongst the text.

这是我迄今为止尝试过但不起作用的方法:

Here's what I've tried to do so far but it doesn't work:

=COUNTIF(Sheet2!A2:A3187,"(CLOSED)")

请问有人能指出我正确的方向吗?

Please can someone point me into the right direction?

推荐答案

请尝试:

=COUNTIF(A:A,"*(CLOSED)*")+COUNTIF(A:A,"*(DO NOT USE)*")

这篇关于计算 A 列中包含“(CLOSED)"的所有行或“(请勿使用)"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！