Array formula

[Pete]

Hi - I was wondering if someone could tell me how to do
the following calculation:

In sheet1 called 'Eigenvectors' I have a 75 by 75 matrix
of co-efficients.

In sheet2 called 'values' I have a 75 by 2000 matrix of
data values.

In a third spreadsheet I want to create a matrix of the
same dimensions as 'values'. each value in this matrix
should be calculated such tthat:
A1=SUM
(EigenvectorsA1*valuesA1,EigenvectorsA2*valuesB1,Eigenvecto
rsA3*valuesC1,...EigenvectorsA75*valuesBW1)

A2=SUM
(EigenvectorsA1*valuesA2,EigenvectorsA2*valuesB2,Eigenvecto
rsA3*valuesC2,...EigenvectorsA75*valuesBW2)

B1=SUM
(EigenvectorsB1*valuesA1,EigenvectorsB2*valuesB1,Eigenvecto
rsB3*valuesC1,...EigenvectorsB75*valuesBW1)

etc...

I was hoping I could do this by an array formula such as:
={SUM('EigenVectors'!B$5:B$75*Values!C1:BW1)}


hope someone can advise.

Pete

 

[Jerry W. Lewis]

=SUMPRODUCT('EigenVectors'!B$5:B$75,TRANSPOSE(Values!C1:BW1))

array entered (Ctrl-Shift-Enter)

Jerry

Pete wrote:

....

 

[Guest]

Thanks - that works well.

Pete

-----Original Message-----
=SUMPRODUCT('EigenVectors'!B$5:B$75,TRANSPOSE(Values! C1:BW1))

array entered (Ctrl-Shift-Enter)

Jerry

Pete wrote:

....

.