How to Multiply Columns in Excel 2016

Опубликовано: 16 Июль 2026
на канале: Excel, Word and PowerPoint Tutorials from Howtech
68,797
60

In this HowTech written tutorial, we’re going to show you how to multiply columns in Excel 2016.

Don't forget to check out our main channel    / howtech   for more free how-to videos!
Join us on Facebook
  / howtechtv  
Our App
http://bit.ly/how-tech

To multiply two columns together and add the sum of all the multiplications use the following example formula: {=SUM(E2:E44*F2:44)}. The curly braces indicate multiplication of arrays which is what we will need in this case. To get the curly braces, either input them manually or hit Shift+Enter while in the cell.

This is a HowTech tutorial, visit our website and watch our videos for more.