Basic Sumproduct question

[Chuck B]

Hi there!
I have a very basic excel question. I have a row of
numbers and a column of numbers (same size). i want to
do a sumproduct on the row and column without doing
A1*B1+A2*C1+A3*D1+ etc...

Is there a way to do this without writing my own function
in VB?

Thanks!

 

[Alan Beban]

=SUMPRODUCT(A1:A3,TRANSPOSE(B11)) array entered.

Alan Beban

 

[Harlan Grove]

=SUMPRODUCT(A1:A3,TRANSPOSE(B11)) array entered.

Or =MMULT(B11,A1:A3) still array-entered, but just one function call.