Matrix Multiplication In Excel Full Story On

SUMPRODUCT is a powerful excel function and is more commonly used to multiply two arrays.

If youre impatient, you can skip the tutorial and download the sample excel file from the end of this post.

Syntax: SUMPRODUCT(array1,array2,array3, ) Array1, array2, array3, are 2 to 255 arrays whose components you want to multiply and then add.

It is important to remember that SUMPRODUCT needs the arrays to be of the same length, else it gives a VALUE error Example 1 of the excel gives you can example of using SUMPRODUCT to multiply two arrays.

Using SUMPRODUCT to divide two arrays Beyond multiplying, SUMPRODUCT also allows you to divide 2 array as you can see in the examples below.

All you need is an array with just 1s of the same length and dimensions as your other arrays.

Note the use of, and; in the array that allows you to define a horizontal or a vertical array.

Do you find this tutorial useful Do you use SUMPRODUCTS a lot If you have a suggestion, a tip or a tutorial comment below and let us know.

Division with SUMPRODUCT Example (1635 downloads) Related Posts: MEDIAN IF tutorial in Excel 2007 and Excel 2010 3 ways to calculate CAGR in Microsoft Excel Excel Tutorial: INDEX MATCH primer How to calculate NPV in Excel using Formulae Excel Tutorial: VLOOKUP primer Excel Tutorial: Introduction to VLOOKUP, INDEX and How to quickly kill a program in Windows Two Variable Data Tables in Microsoft Excel Tutorial Share this: Click to share on Facebook (Opens in new window) Click to share on LinkedIn (Opens in new window) Click to share on Twitter (Opens in new window) Click to share on Pocket (Opens in new window) Click to share on WhatsApp (Opens in new window) Tags: Excel tutorials Leave a Reply Cancel reply Your email address will not be published.

Required fields are marked Comment Name Email Website Notify me of follow-up comments by email.

I consent to my submitted data being collected via this form Thank you for subscribing.

The form collects name and email so that we can add you to our newsletter list for project updates.

Matrix Multiplication In Excel Full Story On

Get more stuff like this in your inbox Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Checkout our privacy policy for the full story on how we protect and manage your submitted data.

Matrix Multiplication In Excel For Mac