Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

This article describes the formula syntax and usage of the PRODUCT function in Microsoft Excel.

Description

The PRODUCT function multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT(A1, A2) to multiply those two numbers together. You can also perform the same operation by using the multiply (*) mathematical operator; for example, =A1 * A2.

The PRODUCT function is useful when you need to multiply many cells together. For example, the formula =PRODUCT(A1:A3, C1:C3) is equivalent to =A1 * A2 * A3 * C1 * C2 * C3.

Syntax

PRODUCT(number1, [number2], ...)

The PRODUCT function syntax has the following arguments:

  • number1    Required. The first number or range that you want to multiply.

  • number2, ...    Optional. Additional numbers or ranges that you want to multiply, up to a maximum of 255 arguments.

Note: If an argument is an array or reference, only numbers in the array or reference are multiplied. Empty cells, logical values, and text in the array or reference are ignored.

Example

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Data

5

15

30

Formula

Description

Result

=PRODUCT(A2:A4)

Multiplies the numbers in cells A2 through A4.

2250

=PRODUCT(A2:A4, 2)

Multiplies the numbers in cells A2 through A4, and then multiplies that result by 2.

4500

=A2*A3*A4

Multiplies the numbers in cells A2 through A4 by using mathematical operators instead of the PRODUCT function.

2250

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×