Open the Excel workbook with required data. For example, suppose you have a table with two columns of data: "volume" and "density". Of them, you need to calculate the total mass of several substances.
Place the cursor in a table cell, which will be entered the result. In this case, the cell next to the column "total mass". Click on main toolbar icon insert function (fx). This will cause the window select the required function. It can also be accessed by clicking the sign Σ AutoSum and selecting in the dropdown menu "Other functions..."
In the window that appears, select the function group "mathematical" and find it "NUMEROITU". A window will appear where you can enter the data ranges for which to calculate the result. This can be done in several ways.
Just highlight with your cursor the first desired range, and it is displayed in the "Array 1". Beside it will display the numeric number that corresponds to the selected data region. The same can be done by specifying the desired data range manually in the format of C2:C6.
In the box "Array 2", specify the following data range in one or another way. You can enter this function from 2 to 30 arrays. Please note that the calculation of this function requires that the number series has been entered in the table with the same capacity. I.e. if the data is within the range specified with two decimal places, when multiplying by an integer value they also need to write in a format with two decimal places, for example, 11,00.
This way you will receive the sum of pairwise products of the two data series without intermediate calculations. If you need to get the same result, but specifying each pairwise works, for example, to further calculate the percentage mass fraction of substances, use the "K".
Call the specified function of one of the above ways. She is also in the group "math". Here you have to fill fields "Number 1" "Number 2", etc. In the field "Number 1" then specify the first cell from the first multiplies the range in the next field – the first cell from the second range, etc. you Can specify up to 30 arguments. Click OK.
Make AutoFill of cells. To do this, hold the cursor lower right corner of the cell with the formula, hold down the left mouse button, drag the selection to the height of the column. The program will automatically perform the multiplication of each pair of cells. At the end of the resulting series insert function AutoSum, if necessary.
Advice 2 : As in Excel, multiply column
Easier operations of multiplication and division, perhaps, only the operations of addition and subtraction. This is true for built-in procedures table editor Microsoft Office Excel multiplication and division of values of the individual cells and entire columns in this exercise easy and pleasant. At least in comparison with operations such as, for example, data from multiple arrays on the computed criteria is also can such an advanced table editor.
You will need
- The table editor Microsoft Office Excel 2007 or 2010.
If the value in each cell of the column must be multiplied by the same number, use a combination of a copy operation and one of the special options for pasting data. For this you have to put a number is a factor of the auxiliary cell select free and enter the desired value. Then copy that cell of the spreadsheet.
Select the range of cells in column multiply. In the group of commands "Clipboard" on the Home tab, open the drop-down list "Insert" and select "paste Special". In the window with the list of options, find "Multiply" in section "Operation" - check the associated check box. Click OK and the values of all selected cells of the column will increase in a given number of times. Next, remove the auxiliary cell with the multiplier.
If the value of the multiplier for each row of the source column should be different, write them into the cells of the auxiliary column. Highlight and copy the range with multipliers, and then repeat the second step. It should also be multiplying the cell values of one column on the value of another, already existing column, but you don't have to create, fill, and remove the helper column.
It is often necessary to keep intact the values of the original column, and multiplying the result to display in another column of the table. In this case, the rows column of the results of multiplication need to fill a simple formula. Start with the first cell, click it with the mouse and type an equal sign. Specify the address of the first multiplying cell by clicking the mouse pointer on it. Then enter the asterisk is the multiplication sign.
You need to make a choice: if you want to use the same multiplier for all rows, enter it, if it is necessary to multiply the cell one row to the corresponding cell to another, click the desired cell with the multiplier. After that, press Enter and the result of the multiplication will appear in the cell with the formula.
Move the mouse pointer to the bottom right corner is just filled with cells and drag the black point down, highlighting in this way the number of rows equal to the height multiplied by the column. So you copy the formula to the whole column of results, and the operation is completed.