How to Use SUMIF Contains in Google Sheets

SUMIF Contains in Google Sheets is a way to find the sum of all cells in a range that meet specific criteria based on a text string. It's not a direct function, but it can be achieved by using a combination of SUMIF and wildcards.

Here's a step-by-step guide on how to use SUMIF Contains in Google Sheets:

1. Start by preparing your data in Google Sheets. Make sure you have a range of cells with the data you want to sum, and another range of cells with the criteria you want to use.
2. In an empty cell, type the following formula:

=SUMIF(range, "*"&criteria&"*", sum_range)

• range: This is the range of cells where the criteria will be applied.
• criteria: This is the text string or cell reference containing the text string you want to use as the criteria.
• sum_range: This is the range of cells that you want to sum if the criteria are met.

3. Replace range, criteria, and sum_range with the appropriate cell references or text strings.
4. Press Enter to get the result.

Example

Let's say you have a list of products and their sales in two columns, and you want to find the sales for all products containing the word "Apple". Here's how you can use the SUMIF Contains formula:

1. Prepare your data in Google Sheets:

2. In an empty cell, type the following formula:

=SUMIF(A2:A6, "*Apple*", B2:B6)

3. Press Enter to get the result. In this case, the result will be 900, as it's the sum of sales for all products containing the word "Apple".