计算A列中所有包含“（CLOSED）”的行。或“（请勿使用）”

我试图通过Excel函数返回A列中所有文本（CLOSED）或（请勿使用）的行的计数）。所有行也将包含其他值，如下所示：

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)

所以我需要在文本中搜索关键字（关闭）或（不使用）。

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)")

请有人可以指点我