sumproduct as Excel

[#1]

Hi people, I need your help with this... see the pic!! Thanks you!!

Marina

[jvishnuram]

Hi Marina,

Try This.,

Rangesum(

Above(

Sum(column(1))

*

Sum(column(2))

,0,NoOfRows()))

[#3]

Hi Vishnu, thanks for answering my question, but the numbers are in the same column... so your expression with column(1) and column(2) doesn't function, there are only 1 column... there are operations by rows, not by columns..

[jvishnuram]

Hi Marina,

Then its so simple use column(1) alone in that expression.

[fernando_tonial]

Hi Marina,

Maybe you try like attach.

[#6]

Thanks Fernando and Vishnu, here I'm attaching the Excel file, look at the red cell, see the function that I'm using, I need this function on Qlikview.

[#7]

how can i attach an xls file??

[#8]

[jvishnuram]

Use advanced editor in the right top.

[#10]

thanks, i've attached there: http://community.qlik.com/message/496126#496126