How to do ProductSum

[chungyin383]

How to evaluate this sum with one formula?

Example:

1 2 3
4 5 6
7 8 9

The formula should return 3240.

 

[Gravitas]

=SUMPRODUCT(1+2*(ROW(INDIRECT("1:"&$A$1))-1))

In A1 your maximum value.

Hope it helps you.

 

[chungyin383]

=SUMPRODUCT(1+2*(ROW(INDIRECT("1:"&$A$1))-1))

In A1 your maximum value.

Hope it helps you.

Thanks but it seems that your formula does not do what I want...
Let me illustrate what I wish to achieve. In the matrix in my example, the column sums are 12, 15, 18 respectively. The product is therefore 3240. Can I use one formula to give 3240 directly?

 

[Aladin Akyurek]

Thanks but it seems that your formula does not do what I want...
Let me illustrate what I wish to achieve. In the matrix in my example, the column sums are 12, 15, 18 respectively. The product is therefore 3240. Can I use one formula to give 3240 directly?

Let I1:K3 house the data.

Control+shift+enter, not just enter:

=PRODUCT(MMULT(TRANSPOSE(I1:K3),ROW(I1:K3)^0))

 

[chungyin383]

Let I1:K3 house the data.

Control+shift+enter, not just enter:

=PRODUCT(MMULT(TRANSPOSE(I1:K3),ROW(I1:K3)^0))

Thanks man! Haven't thought of the use of matrix multiplication in this problem

 

[Aladin Akyurek]

Thanks man! Haven't thought of the use of matrix multiplication in this problem

You are welcome and a happy new year.