COUNTIF

Reference Links

Count cells equal to either X or Y

Reference

Generic Formula

=COUNTIF(range, value1) + COUNTIF(range, value2) 

Alternative syntax using array constants

=SUM(COUNTIF(range, {"x", "y"}))
=SUM(COUNTIF(B5:B10, {"service", "support"}))

QUERY

Reference links for QUERY function

Create a Search Field

I can create a search field in Google Sheets using the =QUERY function like this

=QUERY('Sheet1'!A1:Z99, "select A, B, C where A contains '"&B1&"'")

In the previous example field B1 is on Sheet2 and is where the user inputs their search string

In the example above the search term is pulled in from cell B1 in the current sheet and cell B2 shows how many rows are returned.

In the example above the search term is pulled in from cell B1 in the current sheet and cell B2 shows how many rows are returned.