{=$A$4:$A$11*C5:J5} Pls Help w/ Basic Array Formula

[Gcook888]

The $A$4:$A$11 column is {1;1;0;0;0;0;0;0}.

The C5:J5 row is {1,.707,0,-.707,-1,-.707,0,.707}

I pasted the Array Formula {=$A$4:$A$11*C5:J5} in the column range M4:M11.

I am trying to get the "inner product w/o summing" which should be

{1*1; 1*.707; 0*0; 0*(-.707); 0*(-1); 0*(-.707); 0*0; 0*.707}.

I am getting the answer {1; 1; 0; 0; 0; 0; 0; 0}.

I have tried w/several different rows of numbers. I know this is supposed to
work if both arrays are vertical...

 

[Gcook888]

{=$A$4:$A$11*transpose(C5:J5)}.

Got it. Writing the question helped me think up the answer.

 

[Tom Ogilvy]

Array enter in M4:M11

=A4:A11*TRANSPOSE(C5:J5)

worked for me.

 

[Biff]

Hi Gcook,

The arrays need to be the same size and shape. This works:

{=A4:A11*TRANSPOSE(C5:J5)}

Biff