Shorten Sumproduct formula

[Jesse]

Hi there, how can we shorten this?

=SUM(SUMPRODUCT(A1:W1,A11:W11),SUMPRODUCT(A2:W2,A12:W12),SUMPRODUCT(A3:W3,A13:W13),SUMPRODUCT(A4:W4,A14:W14))


It's summing the sumproduct of 4 paired arrays.. I've tried using [code]MMULT with TRANPOSE

, but it doesn't give me the same result:


=SUM(MMULT(A1:W4,TRANSPOSE(A11:W14)))[/code]


Any ideas? And I'm confused as to why my solution doesn't work.


Merci.

 

[Debraj]

Hi Merci,


Not sure, but looks, below will works the same..

=SUMPRODUCT(A1:W4,A11:W14)

Regards,

Deb

 

[Jesse]

Goodness! How did I miss that one.


Merci (aka "Thank you" in French) Deb


Jesse

 

[Debraj]

Goodness! Comment j'ai pu rater celui-là..


Thank you for feedback and a return back the favor by giving a WORD power..


Merci..


Regards,

Deb