PRODUCT
ThePRODUCT
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.
 How to use
PRODUCT
formula?  Examples of using
PRODUCT
formula PRODUCT
formula not working? Similar formulas to
PRODUCT
Usage
Use the PRODUCT
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 factor1 (required):
The first factor to multiply.  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 thePRODUCT
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.
NonNumeric 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.