SUMPRODUCT Problem

[Guest]

Hi,

It doesn't look like I can get SUMPRODUCT to work on a vertical array and a
horizental array. For example, SUMPRODUCT(A2:A5, B6:E6) gives #VALUE!.
SUMPRODUCT(A2:A5, TRANSPOSE(B6:E6)) or SUMPRODUCT(TRANSPOSE(A2:A5), B6:E6))
also does not work.

I guess I can use MMULT(B6:E6, A2:A5), but does any one know how to get
SUMPRODUCT to work?

Thanks,
Geoffrey

 

[Guest]

Because of the Transpose function, you need to array-enter the formula --
ctrlshift/enter.
Bob Umlas
Excel MVP