EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel PRODUCT Function in Excel
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

PRODUCT Function in Excel

By Madhuri ThakurMadhuri Thakur

PRODUCT Function in Excel

PRODUCT Function in Excel (Table of Contents)

  • Introduction to PRODUCT Function in Excel
  • Examples of PRODUCT Function

Introduction to PRODUCT Function in Excel

Being an Excel user, you might have fallen into a situation where you need to multiply two or more numbers. While excel has different ways to do so, there is one popular way among all, and that is using the PRODUCT function. Using this function, you can do a product of (or Multiply) two or more than two numbers spread along with different cells of your Excel sheet. PRODUCT function in Excel is categorized under Math/Trigonometric function. This function takes at least one argument as an input and gives multiplication of the numbers as an output. If only one argument is provided, then it multiplies that number with 1 and gives the output as a product. It is helpful when you have data scattered along with the ranges.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

The syntax for PRODUCT Function:

product function syntax

Arguments of PRODUCT Function:

  • number1 – Is the required/mandatory argument that specifies the number to be multiplied.
  • number2 – [optional] The second number or range to multiply.

Examples of PRODUCT Function

Let’s look at some examples of the Excel PRODUCT function and see how to use the PRODUCT function in Microsoft Excel.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,412 ratings)
You can download this PRODUCT Function Excel Template here – PRODUCT Function Excel Template

Example #1 – Multiplication of Three Numbers Using PRODUCT Function

Suppose we have numbers to be multiplied in column A of the current working sheet as shown below:

product function in excel 1-1

All we need is a product (multiplication) of these three numbers under cell B2 of the current working sheet.

Step 1: Start typing the PRODUCT formula in cell B2 of the current working sheet.

product function in excel 1-2

You can alternatively add this formula using the Formulas tab present in the uppermost ribbon of your excel sheet.

Go to “Formulas” > “Math & Trig” > “PRODUCT” > Enter.

Step 2: Provide an argument for the PRODUCT function. In this case, you want the product/multiplication of numbers present in cells A2, A3, and A4. Therefore give A2:A4 as an argument under the PRODUCT function.

product function in excel 1-3

Step 3: Complete the formula by entering the closing parenthesis and press the Enter key. You’ll see the multiplication of three numbers as an output under cell B2.

product function in excel 1-4

Example #2 – Difference Between PRODUCT and General Multiplication

In this example, we are going to see how the PRODUCT function is more versatile than the general multiplication we do use an asterisk (“*”). Suppose we have data as shown in the screenshot below:

PRODUCT Function in Excel 2-1

We can see that there are some blank cells between the numbers in column A.

Step 1: In cell B2, try to do multiplication of all the cells with each other (including blank cells) with the help of multiplication operator, a.k.a. asterisk (“*”).

PRODUCT Function in Excel 2-2

Step 2: Press the Enter Key to see the output. You’ll get Zero under cell B2 of the current working sheet. See the below screenshot for your reference.

PRODUCT Function in Excel 2-3

This is because if we left the cell empty, the multiplication operator considers the value as zero for that cell and multiplies it with other numbers, which ultimately gives zero as output.

Step 3: Now use the PRODUCT function over the same range of data (A2:A11). Use the following formula under cell B3.

PRODUCT Function in Excel 2-4

Step 4: Press the Enter key to see the output of this formula under cell B3. You’ll see an output as shown below.

PRODUCT Function in Excel 2-5

This is because the PRODUCT function ignores the cells with blanks, texts, or non-numeric data and gives product/multiplication of those cells with numeric data in them.

Example #3 – PRODUCT Function in Combination with SUM Function

We also can use the PRODUCT function in combination with different mathematical/trigonometric functions. Let’s see how the SUM function can be used within the PRODUCT function. Suppose we are having two offices across the city and employees are working on both offices altogether with some work from home facility available for them.

We wanted to check the product of hours an employee worked under office A & B (Sum of Office & Work From Home Hours). This can be done using the combination of function SUM and PRODUCT. See the data below:

product Example 3-1

Step 1: In cell E2 of the active worksheet, start typing the formula for the PRODUCT function, which is =PRODUCT.

product Example 3-2

Step 2: Now, use SUM(A2, B2) as a first argument under the PRODUCT function and SUM(C2, D2) as a second argument under the PRODUCT function.

product example 3-3

After using the PRODUCT, the Formula output is shown below.

product example 3-4

Step 3: Close the parentheses and press Enter key to see the output of this formula. Also, drag the formula across the different rows to get the final output as below.

product function 1

This might not look like a convenient way to capture the final hours. But this example is created to just make you understand how the SUM can PRODUCT function can be used in combination.

Example #4 – PRODUCT Function Inside Some Other Function

We can also use the PRODUCT function inside any other function. Suppose we have data as shown in the table below, and all we wanted is to make the sum of the product of A2, B2, and product of C2, D2.

product example 4-1

Step 1: In cell E2 of the Active worksheet, start typing the formula for SUM.

product example 4-2

Step 2: Now, use PRODUCT(A2, B2) as a first argument and PRODUCT(C2, D2) as the second argument inside the SUM function, as shown below.

product example 4-3

Step 3: Close the parentheses and press Enter key to see the output under cell E2. You’ll see an output as shown below.

product example 4-4

Here, first, the product of A2, B2 is 12, and that of C2, D2 is 32. Thus, 12 and 32 would be the two arguments under the SUM function. In the end, the SUM function adds both of them and gives the output as 44.

Drag the formula across the cells to see the output for all working cells as below.

product function 2

This is from this article. Let’s wrap the things up with some points to be remembered:

Things to Remember About PRODUCT Function in Excel

  • PRODUCT function accepts a maximum of 255 arguments at a time.
  • The numbers can be added separately or can be stored under cells and used those cells as a reference to the PRODUCT function.
  • If the cells are left blank, stored with numbers as text, logical texts, etc., the PRODUCT function ignores such cells while performing calculations.
  • If the cells are consisting of any other text values such as a name of a person, the PRODUCT function gives #VALUE! error.
  • Product function only takes numeric arguments and work on those. If the cells given as arguments to PRODUCT function are containing either text, blank cells are ignored by this formula. Which can be considered as an advantage of it over conventional multiplication.

Recommended Articles

This is a guide to PRODUCT Function in Excel. Here we discuss How to use the PRODUCT Function in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. COUNTA Function in Excel
  2. SUMPRODUCT Formula in Excel
  3. SUM Function in Excel
  4. SUMPRODUCT Function in Excel
Popular Course in this category
MS Excel Training Bundle
  13 Online Courses |  100+ Hours |  Verifiable Certificates |  Lifetime Validity
4.5
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel for HR Training (8 Courses, 10+ Projects)4.8
2 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download PRODUCT Function Excel Template

EDUCBA

Download PRODUCT Function Excel Template

EDUCBA

डाउनलोड PRODUCT Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more