PRODUCTformula 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
- Examples of using
PRODUCTformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
PRODUCTformula 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.
To calculate the factorial of a number, you can use the
PRODUCT formula to multiply all the integers from 1 to that number.
PRODUCTnot working? Here are some common mistakes people make when using the
PRODUCTGoogle Sheets Formula:
One or more arguments are missing, causing the formula to return an error. Make sure to include all required arguments.
There are too many arguments included in the formula. Remove any extra arguments to fix the error.
One or more of the arguments are not numeric, causing the formula to return an error. Make sure all arguments are numeric.
Using PRODUCT within another function can cause errors. Make sure to use the correct syntax when nesting functions.
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:
SUMfunction in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells.
COUNTformula 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.
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.
MAXfunction 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.
MINformula 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.