## How do I multiply a table in Excel with a table?

How to multiply two numbers in Excel

1. In a cell, type “=”
2. Click in the cell that contains the first number you want to multiply.
3. Type “*”.
4. Click the second cell you want to multiply.
5. Press Enter.
6. Set up a column of numbers you want to multiply, and then put the constant in another cell.

## How do I multiply data in a column in Excel?

Multiply a column of numbers by a constant number

1. Type =A2*\$B\$2 in a new column in your spreadsheet (the above example uses column D). Be sure to include a \$ symbol before B and before 2 in the formula, and press ENTER.
2. Drag the formula down to the other cells in the column.

How do you create a multiplication table?

Go to the first table and fill in the number 1 in each cell of the first column.

1. Then go to the second table and fill in the number 2 in each cell of the first column. Fill in the number 3 in the third column, and so forth.
2. Go back to the first table, and fill in the numbers 1 through 10 in the third column.

How do I get Excel cells to multiply?

To multiply a series of cells, enter a colon between two cell names to indicate that all cells within that range should be multiplied. For example, “=PRODUCT(A2:A5)” indicates that cells A2, A3, A4, and A5 should be multiplied.

### How do you multiply two columns and sums in Excel?

In Excel, there is a powerful function – SUMPRODUCT, with it, we can quickly multiply two columns and then sum them….Multiply two columns and then sum based on one condition with a useful feature

1. Select Math from the Formula Type drop down list;
2. In the Choose a formula listbox, select SUMPRODUCT with criteria option;

### How do you multiply columns in sheets?

2. Type “=” to start the formula.
3. Enter the first number you want to multiply.
4. Input an asterisk.
5. Enter the second number you want to multiply.
6. Press “Enter.”