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