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.