SUMPRODUCT problem

[smallxyz]

The following formula doesn't work. Why??
Thanks.


=SUMPRODUCT({D2;E2;F2},{C5,C6,C7})


=SUMPRODUCT(TRANSPOSE(D2:F2),{C5,C6,C7})

 

[AliGW]

What does the data in those ranges look like? What are you trying to achieve? Define "doesn't work" - it's much too vague.

 

[smallxyz]

All are numbers.
Doesn't work means it returns error.
Essentially it is column by column sumproduct

 

[AliGW]

Provide some sample data and expected outcomes, please. Which error message?

 

[inactiveuserps07]

Small, enter it as below and be sure to hit [Ctrl]+[Shift]+[Enter] to enter it as an array function:

=SUMPRODUCT((TRANSPOSE(D2:F2))*(C5:C7))

 

[zimbra]

Are you hitting Ctrl+Shift+Enter?

 

[inactiveuserps07]

As long as you remember to enter this with Ctrl+Shift+Enter, there are many ways it would/should work:

=SUMPRODUCT((TRANSPOSE(D2:F2))*(C5:C7)) ... my norm, for clarity, grouped and using the array "and" function (*)

=SUMPRODUCT(TRANSPOSE(D2:F2)*C5:C7) ... same as above, but ungrouped

=SUMPRODUCT(TRANSPOSE(D2:F2),C5:C7) ... same as above, but using a comma

 

[Aladin Akyurek]

The following formula doesn't work. Why??
Thanks.


=SUMPRODUCT({D2;E2;F2},{C5,C6,C7})


=SUMPRODUCT(TRANSPOSE(D2:F2),{C5,C6,C7})

TRANSPOSE requires control+shift+enter (CSE)...

Either CSE:

=SUM(TRANSPOSE(D2:F2)*C5:C7)

Or CSE:

=SUMPRODUCT(TRANSPOSE(D2:F2),C5:C7)

 

[inactiveuserps07]

Aladin, interestingly enough, the following two formulas turn up the same result with CSE:

=SUM(TRANSPOSE(D2:F2)*C5:C7)

=SUMPRODUCT(TRANSPOSE(D2:F2)*C5:C7)

 

[taxcel rose]

Hi,

you could also try =MMULT(D2:F2,C5:C7)

Michael