PRODUCT

Formulas / PRODUCT
Multiply numbers given as arguments.
=PRODUCT(number1,[number2],...)
  • number1 - required argument that is the first number or range to multiply
  • number2 - [OPTIONAL] second number or range to multiply

Examples

  • =PRODUCT(3,8)

    The PRODUCT function returns the product of two or more numbers. For example, this returns 24, since 3 x 8 = 24.

  • =PRODUCT(3,8,4)

    The PRODUCT function can also handle three or more numbers. For example, this returns 96, since 3 x 8 x 4 = 96.

  • =PRODUCT(A1:A4)

    You can also use PRODUCT to multiply the contents of a range of cells. For example, if you have the numbers 1, 2, 3, and 4 in cells A1, A2, A3, and A4, respectively, then the formula will return 24, since 1 x 2 x 3 x 4 = 24.

  • =PRODUCT(A1:A4, 6, 8)

    You can also use PRODUCT to multiply a mix of numbers and cell ranges. For example, this will return 1152, since 1 x 2 x 3 x 4 x 6 x 8 = 1152.

  • =PRODUCT(A1, B2, 8, 10)

    You can also use PRODUCT to multiply a mix of numbers and cell references. For example, this will return the product of the contents of cells A1 and B2 with the numbers 8 and 10. If A1 contains 2 and B2 contains 3, the the result will be 480, since 2 x 3 x 8 x 10 = 480.

Summary

The PRODUCT function is a useful tool for multiplying numbers together. It takes multiple arguments, such as constants, cell references or ranges, and multiplies them all together, ignoring empty cells and text.

  • The PRODUCT function takes up to 255 arguments which can be hardcoded constants, cell references, or ranges.
  • The arguments are multiplied together, though empty cells and text values are not ignored.
  • PRODUCT ignores text and empty cells in the argument.


Frequently Asked Questions

What is the PRODUCT function in Sourcetable?
The PRODUCT function is a Sourcetable function that multiplies numbers together. It can take up to 255 arguments, which can be hardcoded constants, cell references, or ranges.
What types of arguments can the PRODUCT function take?
The PRODUCT function can take up to 255 arguments, which can be hardcoded constants, cell references, or ranges.
How does the PRODUCT function handle empty cells and text values?
The PRODUCT function ignores empty cells and text values.
What are some uses of the PRODUCT function?
The PRODUCT function can be used to:
  • Multiply numbers in a range
  • Multiply hardcoded constants
  • Multiply cell references

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV