How to sum the product of 1 row with 1 column?

[Whospal]

I have a column D110 with various value.
And a row with A15:J15.
Is there any quick formula to perform the following?
K15 = (D1*A15)+(D2*B15)+(D3*C15)+...+(D9*I15)+(D10*J15)

 

[prabhuraaman]

Copy the values to another sheet
Copy range D110 to A1:A10
Copy transpose range A15:J15 to B1:B10
Now use the following function:

=SUMPRODUCT(A1:A10,B1:B10)

If you like this solution, you may also like
http://groups.google.co.in/group/Answers-for-everything/browse_thread/thread/946502c223298627
http://groups.google.co.in/group/Answers-for-everything/browse_thread/thread/1b7a6ecc82c9cb75

For more,post your questions on
http://groups.google.co.in/group/answers-for-everything
or e-mail to
(e-mail address removed)

 

[Harlan Grove]

(e-mail address removed) wrote...

Copy the values to another sheet
Copy range D110 to A1:A10
Copy transpose range A15:J15 to B1:B10
Now use the following function:

=SUMPRODUCT(A1:A10,B1:B10)

Why not just use the array formula

=MMULT(A15:J15,D110)

referring to the original cells?

If you like this solution, you may also like

....

So if the OP didn't like your solution, what should he do? Plonking?