| Home > Forum Home > Analyzing Corporate Financial Data > VALUE! > Multiply multiple columns in Excel | Share |
Multiply multiple columns in Excel
Excel Help for Multiply Multiple Columns In Excel in Analyzing Corporate Financial Data
| Forum Topic | Login |
Multiply Multiple Columns In Excel | Rate this: (4/5 from 3 votes) |
 |
To multiply more than two columns in Excel, you can use the multiplication formulas, but include several cells or ranges. For example, to multiply values in columns B, C and D, use one of the following formulas: Multiplication operator: =A2*B2*C2PRODUCT function: =PRODUCT(A2:C2)Array formula (Ctrl + Shift + Enter): =A2:A5*B2:B5*C2:C5 Let me know if this helps. Regards, Jerry M. | |
| Jerry M | ||
| Posted by jerry_maguire on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Multiply multiple columns in Excel in the Excel Business Solutions Directory |