sumproduct

[j21f]

I have two arrays - A1:A3 and D5:F5. So, one is horizontal and one is vertical. I would like to use the sumproduct function, but the dimensions of the arrays need to be identical. I tried to use the transpose function, but the transpose function only returns the first number of the array. I need the transpose function (within the sumproduct function) to return a transposed array for the sumproduct to work. Oh, I have been using the CSE feature. Any solutions for this???

 

[Aladin Akyurek]

I have two arrays - A1:A3 and D5:F5. So, one is horizontal and one is vertical. I would like to use the sumproduct function, but the dimensions of the arrays need to be identical. I tried to use the transpose function, but the transpose function only returns the first number of the array. I need the transpose function (within the sumproduct function) to return a transposed array for the sumproduct to work. Oh, I have been using the CSE feature. Any solutions for this???

TRANSPOSE in a formula forces that formula to be confirmed with control+shift+enter just like an IF with a multicell range-object in its condition part. Thus:

=SUMPRODUCT(A1:A3,TRANSPOSE(D5:F5))

will work if confirmed with control+shift+enter instead of just with enter. Given this fact, I'd switch to:


{=SUM(A1:A3*TRANSPOSE(D5:F5))}