How do I multiply the data of one column with data in another, in excel?

Answer 1

Let's say your numbers are in Column A and B.
In a blank column (let's say that C is blank), and in the top cell of that column type:

=A1*B1

Then hit Enter.
The highlighted cell should be C2.
Click in cell C1 and in the lower right cormer of the cell, there should be a little "box" sign. Put your mouse on the little box and drag it down to the bottom of the column of numbers. That will autofill the formula into each cell in column C.

Answer 2

If the data is in columns A and B (starting in row 1) and you're multiplying in column C, put the formula in C1: = A1*B1

Then use highlight (click & drag starting in cell C1) and CTRL-D to copy the formula as far down as you need.

Answer 3

If you have your data that you want to multiply in columns A and B (of the first row of the spreadsheet), then in Column C type out: =A1*B1then press enter.

Answer 4

In an empty column click a cell. Then hit = then click the first cell you want to multiply, then hit * then click the second cell you want to multiply, then hit enter.
Once the formula works for that particular cell click on the cell and double click the little black + sign on the bottom right corner of the cell (it will make the formula shoot down the entire column.)

Answer 5

Assuming that you have data in one column, you want to total up the first column, and then multiple it by the total of the second column

IF the fist column of data was in A1 to A10. in A12 enter the formula: =Sum(A1:A10)
If the second column of data was in B1 to B10, in B12 enter: -SUM(B1:B10)
Finally in C12 enter: =A12*B12

C12 will display the sum of column A times the sum of column B

*******

If what you want to do instead (question is not clear) to the multiple the data in A1 times the data in B1, then the data in A2 times the data in B2, etc, the formula would be =A1*B1
Then repeat (=A2*B2, =A3*B3) until you reach the end of the columns.

Answer 6

use the formula for exsample "=a1*c7"