You can use the following basic formula to create a **MULTIPLY IF** function in Google Sheets:

=ARRAYFORMULA(PRODUCT(IF(A2:A11="string",B2:B11,"")))

This formula multiplies all of the values together in **B2:B11** where the corresponding cell in the range **A2:A11** is equal to “string”.

The following example shows how to use this formula in practice.

**Example: MULTIPLY IF Function in Google Sheets**

Suppose we have the following dataset that shows the total points scored by basketball players on various teams:

We can use the following formula to multiply together each value in the **points** column if the corresponding value in the **team** column is equal to “Mavs”:

=ARRAYFORMULA(PRODUCT(IF(A2:A11="Mavs",B2:B11,"")))

The following screenshot shows how to use this formula:

The product of the values in the **points** column for the rows where **team** is equal to “Mavs” is **700**.

We can verify that this is correct by manually multiplying each of the points values together for the Mavs:

Product of points: 7 * 20 * 5 = **700**

This matches the value that we calculated using the formula.

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

**Additional Resources**

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

How to Use a RANK IF Formula in Google Sheets

How to Use AVERAGEIFS in Google Sheets

How to Calculate Standard Deviation IF in Google Sheets

Thanks a lot. I’m not very familiar with Google Sheets and was trying to find a way to combine IF with PRODUCT correctly. Your article has been clear & helpful