Transpose array sum
 

I have a column in a table with data (A1:A5). Each of these numbers needs to
be multiplied by a row in another table (A1:E1). I need the sum of A1*A1 +
A2*B1...+A5*E1.

Basically I am trying to get the sum of multiples in an array that are of
the same dimension just transposed.

Any help is much appreciated.
Ian

Transpose array sum
 

Try this:

=MMULT(A1:E1,A1:A5)

--
Biff
Microsoft Excel MVP


"SnoHo71" wrote in message
...
I have a column in a table with data (A1:A5). Each of these numbers needs
to
be multiplied by a row in another table (A1:E1). I need the sum of A1*A1
+
A2*B1...+A5*E1.

Basically I am trying to get the sum of multiples in an array that are of
the same dimension just transposed.

Any help is much appreciated.
Ian

Transpose array sum
 

SnoHo71 or Ian -

One way is to array-enter

=SUMPRODUCT(A1:A5,TRANSPOSE(A1:E1))

To array-enter, after you type the ending parentheses, do not press Enter.
Instead, hold down Control and Shift while you press Enter.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"SnoHo71" wrote in message
...
I have a column in a table with data (A1:A5). Each of these numbers needs
to
be multiplied by a row in another table (A1:E1). I need the sum of A1*A1
+
A2*B1...+A5*E1.

Basically I am trying to get the sum of multiples in an array that are of
the same dimension just transposed.

Any help is much appreciated.
Ian