https://community.qlik.com/t5/QlikView/SUMPRODUCT/m-p/1765627#M717840 <P>HI&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/130773">@MANISHBBS12</a>&nbsp;</P><P>Try like below</P><P>Sum(Qty * Profit) gives result like SUMPRODUCT</P><P>Sum(Qty * Profit ) / Sum(Total Qty) gives like&nbsp;<SPAN>SUMPRODUCT(B2:B4,C2:C4)/B5</SPAN></P><P>&nbsp;</P> Wed, 02 Dec 2020 09:44:13 GMT MayilVahanan 2020-12-02T09:44:13Z https://community.qlik.com/t5/QlikView/SUMPRODUCT/m-p/1765588#M717839 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SUMPRODUCT.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/45073i8BD009604F856192/image-size/medium?v=v2&amp;px=400" role="button" title="SUMPRODUCT.png" alt="SUMPRODUCT.png" /></span></P><P>PLZ HELP HOW TO GET SUMPRODUCT -&nbsp;</P><P>=SUMPRODUCT(B2:B4,C2:C4)/B5</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 02 Dec 2020 07:15:58 GMT https://community.qlik.com/t5/QlikView/SUMPRODUCT/m-p/1765588#M717839 MANISHBBS12 2020-12-02T07:15:58Z https://community.qlik.com/t5/QlikView/SUMPRODUCT/m-p/1765627#M717840 <P>HI&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/130773">@MANISHBBS12</a>&nbsp;</P><P>Try like below</P><P>Sum(Qty * Profit) gives result like SUMPRODUCT</P><P>Sum(Qty * Profit ) / Sum(Total Qty) gives like&nbsp;<SPAN>SUMPRODUCT(B2:B4,C2:C4)/B5</SPAN></P><P>&nbsp;</P> Wed, 02 Dec 2020 09:44:13 GMT https://community.qlik.com/t5/QlikView/SUMPRODUCT/m-p/1765627#M717840 MayilVahanan 2020-12-02T09:44:13Z