Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MANISHBBS12
Contributor
Contributor
‎2020-12-02 02:15 AM

SUMPRODUCT

SUMPRODUCT.png

PLZ HELP HOW TO GET SUMPRODUCT - 

=SUMPRODUCT(B2:B4,C2:C4)/B5

 

 

430 Views
0 Likes
1 Reply
MayilVahanan
MVP
MVP
‎2020-12-02 04:44 AM

HI @MANISHBBS12 

Try like below

Sum(Qty * Profit) gives result like SUMPRODUCT

Sum(Qty * Profit ) / Sum(Total Qty) gives like SUMPRODUCT(B2:B4,C2:C4)/B5

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
399 Views
0 Likes