Google Sheets Tips

Count number of non-blank values:

• =COUNTA(B:B)

Count a String value:

• =COUNTIF(A:A;"value")

Nested Count If

• =COUNTIFS(B:B, "Green", C:C, "No")

Count String contains value

• =COUNTIF(A:A, "*TEST-*")

---

List if the website is included.

• =ARRAYFORMULA(IF( ISNUMBER(FIND("example.com", A2:A)), "Yes", "No"))

Now Filter Views can be used on that boolean column to only display rows that match.

A	B
URL	Internal Domain?
example.com	=ARRAYFORMULA(IF( ISNUMBER(FIND("example.com", A2:A)), "Yes", "No"))
otherwebsite

---

Filter in one list and not another.

• =filter('sheet_1'!A:A,isna(match('sheet_1'!A:A,'sheet_2'!A:A,0)))

--

Filter out one column based on the value of another.

A	B
TRUE	A
FALSE	B

• =filter(B1:B, A1:A=TRUE)

Shows all values of B where column A is TRUE.