As in Excel, multiply the column by the column and column by the number

Those people who often work at a computer, sooner or later will encounter such a program as Excel. But the conversation in the article will not go about all the pros and cons of the program, but about its separate component "Formula." Of course, in schools and universities in the lessons of computer science students and students are trained on this topic, but for those who have forgotten, - our article.

The conversation will be about how to multiply a column in Excel by a column. A detailed instruction will be provided on how to do this, with a step-by-step analysis of each item, so that everyone, even a beginning student, will be able to understand this question.

Multiply column by column

As in Excel, multiply the column by a column, we will disassemble the example. Let's imagine that in the Excel workbook you have created a table with the cost and quantity of the product. Also you have a cell at the bottom with a total amount. As you can imagine, you need to quickly multiply the first two columns and find out their amount.

So, here's the step-by-step instruction:

1. Select the desired cell and click on the function icon, which is located at the top of the main toolbar.
2. Before you will be a window in which you will need to select "Other functions".
3. Next, you must choose from the group of functions mathematical.
4. Choose "SUMPRODUCT".

After that, a window will appear asking you to select the range with the required data, here you can go in two ways. The first implies that you use the cursor to select the first column (cost) and its range will be specified in "Array 1", and the second (price) will be specified in "Array 2". As you can see, the range was specified in the symbols (C2: C6). The second way means that you will enter these values manually, there is no difference from this.

Now you know one way of how to multiply a column by a column in Excel, but it's not the only one, and we'll talk about the latter in the text below.

The second way of multiplying

To multiply the columns in the second way, you will also need to select a group of "mathematical" functions, but now you need to use "WORK". Now before you there are two fields: "Number 1" and "Number 2". Click on "Number 1" and select the first value from the first column, similarly repeat the steps with "Number 2", just select the first value of the second column.

After clicking "OK" in the cell with the formula, the product of the selected values appears, it only remains to autocomplete the cells, to do this, move the cursor to the bottom right edge of the cell and drag it down to the required number of points.

Now you've learned the second way of how to multiply the column in Excel by a column. Now let's talk about how to multiply a number by a column.

Multiply the column by the number

So, how to multiply a column in Excel by a number? In fact, it's even simpler. For this:

1. Select the cell where the result will be located.
2. Write the "equals" sign in it.
3. Use the cursor to select the first value from the column, and then select the number to which this value will be multiplied.
4. After that, move the cursor to this number and press the F4 key.
5. Now you just need to move the cursor to the bottom right corner of the cell with the answer and drag it to the required number of points.