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