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.