Check Sheet Logo
Check Sheet

PRODUCT

The PRODUCT formula in Google Sheets multiplies all the numbers given in the arguments and returns the product. It is commonly used to calculate the total product of a range of cells.

Usage

Use the PRODUCT formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:

=PRODUCT(factor1, [factor2, ...])
Parameters:
  1. factor1 (required):
    The first factor to multiply.
  2. factor2, ... (optional):
    Additional factors to multiply, up to a maximum of 30.

Examples

Here are a few example use cases that explain how to use the PRODUCT formula in Google Sheets.

Calculating the total sales

To calculate the total sales of a product in a given period, you can use the PRODUCT formula to multiply the units sold and the unit price for each sale.

Calculating compound interest

To calculate the total amount of money after compound interest has been added, you can use the PRODUCT formula to multiply the initial amount by (1 + interest rate) raised to the power of the number of periods.

Calculating factorial

To calculate the factorial of a number, you can use the PRODUCT formula to multiply all the integers from 1 to that number.

Common Mistakes

PRODUCT not working? Here are some common mistakes people make when using the PRODUCT Google Sheets Formula:

Missing Arguments

One or more arguments are missing, causing the formula to return an error. Make sure to include all required arguments.

Extra Arguments

There are too many arguments included in the formula. Remove any extra arguments to fix the error.

Non-Numeric Values

One or more of the arguments are not numeric, causing the formula to return an error. Make sure all arguments are numeric.

Nested Functions

Using PRODUCT within another function can cause errors. Make sure to use the correct syntax when nesting functions.

Incorrect Syntax

Make sure the syntax of the formula is correct, including the use of commas between arguments.

Related Formulas

The following functions are similar to PRODUCT or are often used with it in a formula:

  • SUM

    The SUM function in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells.

  • COUNT

    The COUNT formula returns the number of numeric values within a specified range of cells. It is commonly used to count the number of entries in a given range that meet specific criteria, such as counting the number of sales above a certain threshold.

  • AVERAGE

    The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

  • MAX

    The MAX function returns the maximum value from a range of cells or a set of supplied values. It is commonly used to find the largest value in a dataset.

  • MIN

    The MIN formula is a statistical function that returns the smallest value in a set of numbers. It is commonly used to find the minimum value from a range of cells or a list of values.

Learn More

You can learn more about the PRODUCT Google Sheets function on Google Support.