sumproduct row * column ?

[cnestg8r]

I know each array used in sumproduct are to have the same dimension. However, I want to use a row and column array. Is there a work around?

 

[Scott Huish]

Can you give details about what you are trying to do exactly?

 

[cnestg8r]

Sorry about the duplicate. I want to multiply and sum (as example) a2:a7 and b3:g3.

 

[Oaktree]

Maybe you're looking for:

=MMULT(C1:E1,B2:B4) ?

 

[cnestg8r]

That might work with a SUM. I'll try it. Thanks

 

[cnestg8r]

Sorry no SUM needed

 

[pgc01]

Hi cnestg8r

I want to multiply and sum (as example) a2:a7 and b3:g3.

Not clear what you want.

Can you post the result as a simple expression, like:

=a2*b3+a3*c3+a4*d3 ...

In this case, for ex.:

=SUM(A2:A7*TRANSPOSE(B3:G3))
Confirmed with CTRL+SHIFT+ENTER

 

[cnestg8r]

Thanks to all. The MMULT solution worked, but so does pcg01's approach. I appreciate adding both of them top my arsenal.