Transpose array sum

  • Thread starter Thread starter SnoHo71
  • Start date Start date
S

SnoHo71

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
 
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
 
Back
Top