=SUMPRODUCT(A1:A10,TRANSPOSE(A1:J1)) as this is now an array function and to have it evaluated one need to press CTRL-SHIFT-ENTER (Or Command-ENTER for MAC) and not just enter. The alternative solution would be to use: Raising the result to the power of zero simply converts all numbers in the array to 1. One could argue that in fact one should only be interested in using a formula on the form =MMULT(A1:J1,A1:A10). The COLUMN function is used to create a numeric array with 3 columns and 1 row, and TRANSPOSE converts this array to 1 column and 3 rows. If you don't understand why, I strongly recommend to use the approach given below. However make sure when you conduct your matrix multiplication that you are multiplying in the right order! There is a big difference between =SUM(MMULT(A1:J1,A1:A10)) and =SUM(MMULT(A1:A10,A1:J1)). It will do exactly the same as the matrix multiplication formula MMULT. It is possible to use this function with by transposing the row (or column). This is a bit of a late reply, however got directed here from Google so found it appropriate to add a few comments to make this work.įirst of all always make sure that the sizing of the rows and columns match. Step 2: Put & symbol and apply TEXT in excel formula, and inside the TEXT. In 8 2 the 2 says to use 8 twice in a multiplication, so 8 2 8 × 8 64. Re: Multiplying rows by columns and sum them Good for adding formulas to a range of cells where cell references should. On a mac, there is such thing as a Character Palette.
