How to Multiply Multiple Cells in Excel – 4 Methods

The sample dataset showcases product quantity and unit price.


Method 1 – Using the Asterisk Sign to Multiply Multiple Cells in Excel

Steps

  • Select a cell to display the value.

  • In the formula bar, enter the equal sign (=). Supply your cell reference. Here, C5 is multiplied by D5. Enter the formula.
 =C5*D5

Multiply Multiple Cells in Excel Using Multiplication Operator

  • Press Enter.

Multiply Multiple Cells in Excel Using Multiplication Operator

  • Drag down the Fill Handle to apply the formula to the rest of the cells.

Read More: How to Multiply Two Columns in Excel


Method 2 – Applying the PRODUCT Function to Multiply Multiple Cells

Steps

  • Select a cell to display the value.

  • Enter the equal sign (=) in the formula box.
  • Enter Product.
  • Enter number 1 (the first  cell) and number 2 (the second cell). More numbers can be used separated by a comma.

Applying Product Function to Multiply Multiple Cells in Excel

  • To multiply C5 by D5, enter the following function.
=PRODUCT(C5,D5)

Applying Product Function to Multiply Multiple Cells in Excel

  • Press Enter.

Applying Product Function

  • Drag down the Fill Handle to apply the formula to the rest of the cells.

Applying Product Function to Multiply Multiple Cells in Excel

Read More: How to Create a Multiplication Formula in Excel


Method 3 – Multiplying Multiple Cells with a Constant Value in Excel

 

3.1 Using Paste Special Command

Steps

  • Set a constant value in a blank cell. Here, ‘5’ .
  • Copy it and select the range of cells you want to multiple by the constant value.

  • Go to the Home tab and click Paste.

  • In Paste, select Paste Special.

Using Paste Special Command

  • In the Paste Special dialog box, select All in Paste, and Multiply in Operation.
  • Click ‘OK’.

Using Paste Special Command to Multiply Multiple Cells in Excel

This is the output.

Using Paste Special Command to Multiply Multiple Cells in Excel


3.2 Applying a Formula in Excel

Steps

  • Enter a constant value in a blank cell.
  • Select a column to display the result of the multiplication.

  • Enter the Equal Sign (=). Select the cell reference and the constant value cell reference. Use the Asterisk Sign (*) between the two cell references. Enter the following formula:
=E5*$H$5

  • Press Enter to see the result.

Utilizing Formula in Excel

  • Drag down the Fill Handle to apply the formula to the rest of the cells.

Utilizing Formula in Excel

Note: Here, you can see we use a dollar sign ($) to represent the constant value cell reference. The dollar sign can transform the constant value reference into an absolute cell reference.

Read More: How to Multiply Rows in Excel


Method 4 – Creating an Excel Array Formula to Multiply Multiple Cells

Steps

  • Select a cell to enter the Array formula.

  • Enter the Equal sign (= . Enter the following formula.
=SUM(C5:C9*D5:D9)

Using Array Formula in Excel

  • Press Ctrl+Shift+Enter to apply the formula.

Using Array Formula in Excel


Things to Remember

For an array function press Ctrl+Shift+Enter to apply the formula.


Download Practice Workbook

Download the practice workbook.


 

Related Articles


<< Go Back to Multiply in Excel | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Durjoy Paul
Durjoy Paul

Durjoy Kumar, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, is a dedicated contributor to the ExcelDemy project. His substantial contributions include crafting numerous articles and demonstrating expertise in Excel and VBA. Durjoy adeptly automates Excel challenges using VBA macros, offering valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, SPSS, C, C++, C#, JavaScript, Python Web Scraping, Data Entry... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo