# 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:

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.

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.

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