How can i multiply two columns in excel

This approach might be useful if you want to prevent accidental deletion or alteration of the formula in individual cells. When such an attempt is made, Excel will show a warning that you cannot change part of an array.

To multiply more than two columns in Excel, you can use the multiplication formulas similar to the ones discussed above, but include several cells or ranges. As shown in the screenshot below, the formulas multiply numbers and percentages equally well. In situations when you want to multiply all values in a column by the same number, proceed in one of the following ways. Here's what you do:. In this example, we are going to multiply a column of numbers by percentage. In our sample table, the numbers to be multiplied are in column B beginning in row 4, so the formula goes as follows:.

Double-click the small green square in the lower-right corner of the formula cell to copy the formula down the column as far as there is any data to the left.

That's it! You use a relative cell reference like B4 for the topmost cell in the column, so that this reference changes based on the relative position of a cell where the formula is copied. Please copy or enter the below formula into a blank cell:. Note : In the above formula, C4:C12 , D4:D12 are the two columns range that you want to do the calculation, F4 , G4 are the criteria that you want to calculate based on, and A4:A12 , B4:B12 are the columns contain the conditions you specified.

And then, press Enter key to get the result as below screenshot shown:. Multiply two columns and then sum based on multiple criteria in the same column. If I need to calculate the total price of apples and oranges, please use this formula:. Note : In the above formula, C4:C12 , D4:D12 are the two columns range that you want to do the calculation, F4 , F5 are the criteria that you want to calculate based on, and A4:A12 , isthe columns contains the conditions you specified.

Tips : The above examples are some basic formulas, you can add more criteria as you need within the basic formula. After installing Kutools for Excel , please do as this:. In the Formulas Helper dialog box, do the following operations:. Then, click Ok button, and the calculated result will be displayed at once, see screenshot:. Contact Privacy Policy. Excel Basics. Abdul Kader Sep 28, 0. Table of Contents hide. Practice Spreadsheet. Multiplication of Two Columns and Sum in Excel 1.

Multiplication of Two Columns and Sum without any Criteria. Further Readings. Save Saved Removed 0. Thank you! Any more feedback?

The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped.