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

  • Thread starter Thread starter Gcook888
  • Start date Start date
G

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...
 
{=$A$4:$A$11*transpose(C5:J5)}.

Got it. Writing the question helped me think up the answer.
 
Hi Gcook,

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

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

Biff
 
Back
Top