Google Sheets: How to Use a Concatenate If Formula


The following examples show how to use a concatenate if formula in Google Sheets.

Example 1: Concatenate If (By Column)

Suppose we have the following data in Google Sheets:


We can use the following formula to concatenate cells in column A and B only if the value in column B is equal to “Good”:

=CONCATENATE(IF(B2="Good", A2:B2, ""))

The following screenshot shows how to use this formula in practice:

Google Sheets concatenate if formula

If the cell in column B is equal to “Good” then the value in column C is equal to the concatenation of the cells in column A and B.

Otherwise, this formula simply returns a blank value.

Note: You can find the complete documentation for the CONCATENATE function in Google Sheets here.

Example 2: Concatenate If (By Row)

Once again suppose we have the following data in Google Sheets:


We can use the following formula to concatenate all of the cells in column A where the value in column B is equal to “Good”:

=ARRAYFORMULA(TEXTJOIN("",FALSE,IF(B2:B7="Good",A2:A7,"")))

The following screenshot shows how to use this formula in practice:

Notice that the value in cell C2 is the result of concatenating every value in column A where the corresponding value in column B is equal to “Good.”

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Remove Substring in Google Sheets
How to Extract Numbers from String in Google Sheets
How to Select Rows that Contain String in Google Sheets

Leave a Reply

Your email address will not be published. Required fields are marked *