Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

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
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
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

 

 

Labels (1)
Labels
819 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.
788 Views
0 Likes