Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transpose - array problem | Excel Discussion (Misc queries) | |||
Transpose Array | Excel Discussion (Misc queries) | |||
Conditional transpose to Array | Excel Discussion (Misc queries) | |||
Transpose and order array numbers | Excel Worksheet Functions | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) |