Skip to main content

How to Multiply in Excel: A Step-by-Step Guide

Learn how to multiply in Excel, including how to multiply columns and rows. Learn to use simple formulas as well as functions like PRODUCT() and SUMPRODUCT().
Feb 3, 2025  · 6 min read

In this guide, I’ll show you different ways to multiply numbers in Excel. We’ll start with the basics using the * symbol to multiply numbers, then move on to multiplying entire columns and rows, and even using built-in functions like PRODUCT() and SUMPRODUCT(). By the end, you’ll understand how to multiply efficiently in Excel, regardless of the data you’re working with.

However, if you’re new to Excel, check out our Introduction to Excel course to understand the basics first.

Basic Multiplication in Excel

You can use the asterisk (*) symbol to calculate the product of two or more numbers. To do this, select the cell and type = and enter the first number, then type asterisk * followed by the second number (without space) and press Enter.

For example, if I want to multiply 4 by 5, my expression will look this: 

=4*5

As a note, if you are using other operations also, like +, -, or /, you must follow the PEMDAS rule (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction) to get the correct answer.

Multiplying multiple cells in Excel.

Multiply multiple cells. Image by Author.

Multiply Cells in Excel

Apart from basic numbers, we can even multiply cells for quicker calculations. Whether it's two cells or more, the process stays the same — the only difference is we use cell references instead of fixed numbers here. 

How to multiply two cells in Excel

Let's say cells A2 and B2 contain numbers. In cell C2, I enter =A2*B2 and press Enter. If I change the value in any of the first two cells, it will automatically update the result.

Multiplying two cells in Excel.

Multiply two cells. Image by Author.

How to multiply multiple cells in Excel

If we want to multiply more than two cells, we can extend the formula like this:

=A2*B2*C2*D2

Multiplying multiple cells in Excel.

Multiply multiple cells. Image by Author.


Multiplying Columns and Rows

We can also multiply entire columns and rows in Excel. Let’s see how:

How to multiply columns in Excel

If I want to multiply multiple columns. I’ll enter the following formula in the cell D2

=A2*B2*C2

Once I hit Enter, the result will be calculated. Now, instead of repeating the formula to the other cells, I can drag or double-click on the small green square at the corner of the cell to copy down the formula to the last cell.

Multiplying two columns in Excel.

Multiply two columns. Image by Author.

If any cell is empty but referenced in a formula, Excel treats it as 0. So the formula will return 0.

Multiplying multiple columns in Excel.

Multiply multiple columns. Image by Author.

How to multiply columns by a number in Excel

If I want to multiply the whole column by a single number, I will use the absolute reference $. This means the entire column from A2 to A5 is multiplied by a number in cell B2. My formula will look like this: 

=A2*$B$2

Here, the symbol $ will fix the value of B2, which tells Excel to use that value on every cell when I drag the formula down the column. 

Note: We don’t have to type $ manually. Click on the cell name in the formula, like in my case, B2, and press the F4 key. This will automatically fix the formula.

Multiply columns with an absolute reference in Excel.

Multiply columns with an absolute reference. Image by Author.

How to multiply rows in Excel

Rows work the same way as columns but run horizontally instead of vertically. If I want to multiply row 1 (B1) by row 2 (B2), I will enter

=B1*B2

in a new cell and drag it horizontally to copy it to the rest of the row.

Multiplying multiple rows in Excel.

Multiply multiple rows. Image by Author.

How to multiply rows by a number in Excel

I can use an absolute reference to multiply an entire row by a single number. For example, if the multiplier is in cell C2 and the values are in row 1, I type

=B1*$C$2

in another cell. Then, I drag the formula across the row to apply the multiplication to the whole row.

Multiply two rows with an absolute reference in Excel.

Multiply rows with an absolute reference. Image by Author.

Multiplication Functions in Excel

Excel also has some built-in functions to find the product of numbers. Let’s see what are some commonly used ones and how they work:

Using the PRODUCT() function

We can use the PRODUCT() function in Excel to multiply multiple numbers and ranges all at once. The syntax is simple: 

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

Here number1, number2, and so on, are the ranges or numbers we want to multiply. 

If I want to multiply all the values in cells A2 to A5. I use the formula:

=PRODUCT(A2:A5)

And if I want to multiply the result with any number like 5, my formula will look like this:

=PRODUCT(A2:A5, 5)

Use PRODUCT function to multiply the cells in Excel.

Multiply cells using the PRODUCT() function. Image by Author.

This is helpful when we work with large datasets or want a clean and compact formula instead of writing it manually. What I also like about this formula is that if a cell is empty but referenced in the formula, it will not return 0. This way, I can reference cells where data will be added later, and the formula will still work perfectly.

Using the SUMPRODUCT() function

The SUMPRODUCT() function multiplies two or more lists of numbers and then sums up the results. Its syntax is: 

=SUMPRODUCT(array1, [array2], [array3], ...)

If I want to calculate the total sales of items by multiplying the quantity sold by the price for each item, I can use this formula:

=SUMPRODUCT(B2:B6, C2:C6)

If I were to calculate it manually, the calculation would look like this: (B2*C2)+(B3*C3)+(B4*C4)+(B5*C5). But with SUMPRODUCT(), Excel does all the work in one step, which makes the process more efficient.

Use SUMPRODUCT to multiply and sum the results in Excel.

Multiply and sum using the SUMPRODUCT() function. Image by Author.

This function also works perfectly for financial modeling and data analysis, as we often have to calculate weighted totals and analyze relationships between datasets in these fields.

Other Things That Might Come Up

Finally, let's take a look at a couple of other interesting things that might come up.

Multiplying by percentages in Excel

We can even multiply by percentages in Excel to calculate portions or adjustments. There are two ways to do this: multiply with percentages directly or use decimal equivalents. Let’s understand each:

Direct multiplication with percentages

If I want to multiply a number by a percentage in Excel, I just type = followed by the number, then *, and the percentage with a % sign. For example, to find 40% of 20, I enter

=20*40%

in a cell, which gives 8.

The % sign automatically converts the number into a percentage, which makes calculations easier for me. 

Using decimals instead of percentages

We can also use decimals instead of percentages. For example, I know 40% means 0.4 in decimals, so I can write this formula to find the result, which is 8:

=20*0.4

I can also replace the hardcoded number with the cell reference. (We have 20 in A3, so I referenced it in the formula and see how it gives an accurate answer.)

Multiplying a number or a cell with a percentage in Excel.

Multiply a cell and number by a percentage. Image by Author.

Matrix multiplication in Excel using array formulas

Now, it may sound complicated, but we can even multiply matrices in Excel. Luckily, Excel makes the process as simple as possible with the MMULT() function. 

MMULT() works by multiplying two matrices. It takes each row from the first matrix, multiplies it by each column from the second matrix, and then adds the results. Its syntax is: 

=MMULT(array1, array2)

The resulting matrix will have the same number of rows as the first matrix and the same number of columns as the second matrix.

Basic matrix multiplication.

Matrix multiplication. Image by Author.

For example, I have a 2×3 matrix and a 3×2 matrix. The result will be a 2×2 matrix. So, I first select a 2×2 range where I want the result to appear. Then, I type the following:

=MMULT(B2:D3, C5:D7)

Finally, I press Ctrl + Shift + Enter to apply the formula.

Multiplying two matrices using the MMULT function in Excel.

Multiply matrices using the MMULT() function. Image by Author.

When I use MMULT(), I always check for two things: 

  1. The number of columns in the first matrix must match the number of rows in the second matrix — otherwise, the function won’t work. 

  2. All the cells must have numbers only because if there are empty cells or text, Excel will give a #VALUE! error.

If you are serious about becoming better at linear algebra specifically, try our Linear Algebra for Data Science in R course, which will operations like matrix multiplication. 

 

Advance Your Career with Excel

Gain the skills to maximize Excel—no experience required.

Start Today for Free

Final Thoughts 

We’ve covered multiple ways to multiply in Excel using the simple * symbol and even advanced functions like PRODUCT() and SUMPRODUCT().

If you start using these techniques, you’ll notice how your work becomes much more manageable. That’s because Excel would do the heavy lifting for you, so you can shift your entire focus on data analysis. 

If you want to sharpen your skills, check out our Data Preparation in Excel course to learn how to clean and organize data properly. Otherwise, if you’re interested in presenting insights visually, the Data Visualization in Excel course will help you create clear, impactful charts.


Laiba Siddiqui's photo
Author
Laiba Siddiqui
LinkedIn
Twitter

I'm a content strategist who loves simplifying complex topics. I’ve helped companies like Splunk, Hackernoon, and Tiiny Host create engaging and informative content for their audiences.

How to Multiply in Excel FAQs

How do I multiply by pi in Excel?

In Excel, you can multiply a number by pi (π) using the built-in PI() function. The PI() function returns the value of π (approximately 3.141592654).

For example, to multiply the cell or a number pi, use the formula:

=PI()*A1

or

=PI()*5

How can I quickly multiply all the values in a column by a number without formulas?

You can use Paste Special like this:

  • Copy the multiplier.
  • Select the column values.
  • Right-click > Paste Special >Multiply > OK.

How can I multiply and round the result in one formula?

You can use the ROUND() function like this:

=ROUND(A2*B2, 2)

(rounds the result to 2 decimal places).

How do I display an error if a cell is empty instead of returning 0?

You can use an IF() formula like this:

=IF(OR(A2="", B2=""), "Error: Missing Value", A2*B2)

This will return an error message if either A2 or B2 is empty.

Topics

Learn Excel with DataCamp

course

Data Analysis in Excel

3 hr
72.9K
Learn how to analyze data with PivotTables and intermediate logical functions before moving on to tools such as what-if analysis and forecasting.
See DetailsRight Arrow
Start Course
See MoreRight Arrow
Related

cheat-sheet

Excel Formulas Cheat Sheet

Learn the basics of Excel with our quick and easy cheat sheet. Have the basics of formulas, operators, math functions and more at your fingertips.
Richie Cotton's photo

Richie Cotton

18 min

tutorial

How to Add, Subtract, Divide and Multiply in Spreadsheets

Learn how to apply operations like add, subtract, divide, multiply, and a lot more in Google Spreadsheets with the help of an actual dataset.
Aditya Sharma's photo

Aditya Sharma

9 min

tutorial

How to Calculate Factorials in Excel: A Complete Guide

Learn to calculate factorials in Excel with ease. Discover FACT, FACTDOUBLE, GAMMA functions, and more to solve mathematical and real-world problems.
Elena Kosourova's photo

Elena Kosourova

7 min

tutorial

How to Compare Two Columns in Excel: A Step-by-Step Guide

Learn how to compare two columns in Excel for matches and for duplicates using methods like the equals operator, IF() function, EXACT(), VLOOKUP(), and more.
Laiba Siddiqui's photo

Laiba Siddiqui

9 min

tutorial

The 15 Basic Excel Formulas Everyone Needs to Know

Learn how to add arithmetic, string, time series, and complex formulas in Microsoft Excel.
Abid Ali Awan's photo

Abid Ali Awan

15 min

tutorial

Pivot Tables in Spreadsheets

Learn how to organize rows and columns, add values, find the sum of revenue, and finally apply filtering to select a subset of data from a given dataset.
Aditya Sharma's photo

Aditya Sharma

10 min

See MoreSee More