EXCEL: count all rows in column A for containing text "(CLOSED)" or "(DO NOT USE)"

i am trying to perform an excel function where I can search all the rows in column A and return the total number of results where the text '(CLOSED)' or '(DO NOT USE)' is contained.

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

please can someone point me into the right direction. Thanks in advance