How to Multiply in Google Sheets (Numbers, Cells or Columns)

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 you can 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.

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 formula:

=MULTIPLY(12,14)

 

Multiply formula to multiply two numbers

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:

=MULTIPLY(A1,A2)

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

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:

=12*14

Multiply numbers using operator

In case these values are in cell A1 and A2, you can use the below formula:

=A1*A2

Multiply two cell using opeartor

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:

=A1*A2*A3

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):

=12*14+2

Adding number to the multiplied value without brackets

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):

=12*(14+2)

Adding numbers and then multiplying it using brackets

Also read: How to Divide in Google Sheets

Multiplying Two 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.

Dataset where columns need to be multiplied

Below is the formula that will do this:

=ARRAYFORMULA(A1:A10*B1:B10)

Array formula to multiply columns in Google sheets

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:

=SUMPRODUCT(A1:A10*B1:B10)

So there are some of the ways you can multiply in Google Sheets. Based on whether you want to multiple cells or columns, you can choose from the MULTIPLY function or the operator.

Hope you found this tutorial useful.

Other Google Sheets tutorials you may like:

Leave a Comment