Most people use Google Sheets for two basic purposes – creating a record database or doing simple calculations such as multiplying cells or columns.
There are many ways to multiply columns (or cells or numbers) in Google Sheets and you can use any of the methods based on how your data is structured.
In this tutorial, I will show you various methods of how to multiply in Google Sheets.
Multiplying Two Numbers in Google Sheets
If you have two numbers or two cells that have the numbers that you want to multiply, there are a couple of techniques to do this.
How to Multiply Cells in Google Sheets Using the MULTIPLY Function
Since multiplying numbers is such a common task, Google Sheets decided to have a dedicated MULTIPLY formula in it (it’s not there is MS Excel, in case you’re wondering).
Suppose you want to multiply two numbers (12 and 14), you can use the below multiplication Google Sheets formula:
This MULTIPLY formula is great to use when you only have two numbers and you want to quickly get the resulting value.
While I have hard-coded the numbers in the formula in the above example, you can also use the reference to cells that have these values.
For example, if cell A1 has 12 and A2 has 14, you can use the below formula to get the result:
The MULTIPLY formula can only work with two arguments, but if you have more than two, then this formula will give you an error. Also, you can multiply two formula results or named ranges that refer to a cell
How to Multiply in Google Sheets Using the Multiply Operator
You can also use the multiply operator (an asterisk sign) to quickly multiply two or more cells/numbers in Google Sheets.
Suppose you want to multiply two numbers (12 and 14), you can use the below formula:
In case these values are in cell A1 and A2, you can use the below formula:
With the multiplication operator, you can multiply more than two values. Just use the multiply operator between all the values that you want to multiply.
For example, if you have values in cell A1, A2, and A3, you can use the below formula:
Also, remember that in case any of these cells are empty, the formula will give you 0.
One important thing to know when using a multiplication operator is to follow the order of precedence. For example, if you use the below formula, it will give you 170 (as it first does the multiplication and then adds the 2 to the result):
In case you want to add 2 to 14 first and then multiply, you need to use the below formula (where brackets are used to clearly segregate sections that need to be calculated first):
Also read: How to Divide in Google Sheets
How to Multiply Columns in Google Sheets
While the above examples dealt with multiplying single values or cells, in this section, I will show you how to multiply two columns (or multiply more than two columns) with a simple formula.
Suppose you have the dataset as shown below and you want to get the multiplied value of cells in the row in column C.
Below is the formula that will do this:
Since this is an array formula, you only need to enter this in cell C1 and it will automatically fill the rest of the column cells.
Also, with array formulas, you can not delete or edit a part of the resulting array. You can, however, delete the entire array if you want.
You can also use the below formula to first multiply the cells in the row, and then copy the formula for all the cells in the column.
Since the above is not an array formula, you can change or edit individual cells that you want.
In case you want to get the sum of all the multiplies value in a single cell, you can use the below SUMPRODUCT formula:
Tips for Multiplying in Google Sheets
Check your formulas – if you have a wrong result, it’s likely you’ve messed something small up in the function. Double-check you typed everything correctly
Review the Operators – the multiply operator is * so you shouldn’t have any others except for brackets
Choose the result cell carefully – make sure you’ve selected the right cell that you want to show the result in. The same goes for selecting an appropriate column
Use cell references – once you wrap your head around cell references, it will save you a lot of time compared to writing the formula out manually.
Google Sheets Multiplication FAQ
Can You Multiply Data Across Multiple Rows Without Entering a Formula in Every Row?
Yes you can multiply across multiple rows. the Google spreadsheet formula for multiplication across multiple rows is the ARRAYFORMULA. For example, let’s say you wanted to multiply rows 1-5 in columns A, B, and C. You could use the array formula:
The colon in between the cell references tells the ARRAYFORMULA where to look and the * sign is the Google Sheets multiplication operator.
This will give you results in the entire column. Then, you can simply use one SUM formula if you’d like to get a grand total.
What Is the Formula to Multiply in Google Sheets?
MULTIPLY is the aptly named multiplication function in Google Sheets. For example, you could type:
and you would get a result of 10.
Alternatively, you can use the * operator instead like so:
You’d get the correct answer whichever method you choose.
How Do I Multiply More Than 2 Numbers in Google Sheets?
Unfortunately, the Google Sheets MULTIPLY formula doesn’t work with more than 2 numbers. The simplest way to multiply 2 numbers is to use the * operator, like so:
How to Do Multiplication in Google Sheets
So there are some of the ways you can multiply in Google Sheets. Based on whether you want to multiply cells or columns, you can choose from the MULTIPLY function or the operator.
Hope you found this tutorial on how to multiply in Google Sheets useful.
Other Google Sheets tutorials you may like:
- How to Sum a Column in Google Sheets
- How to Number Rows in Google Sheets (Add Serial Numbers)
- How to Count Cells with Specific Text In Google Sheets
- How To Square In Google Sheets
- Convert Formulas to Values in Google Sheets
- How to Subtract in Google Sheets
- How to Calculate Weighted Average In Google Sheets