Get instant live expert help on sumproduct in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
how to sumproduct multiple rows in excel 2016?
Solved by Z. Y. in 28 mins
Not allowing me to combine a sumproduct and sumif function in excel. Both the sumproduct and sumif functions have multiple criteria
Solved by E. W. in 26 mins
SUMPRODUCT FORMULA GIVES NAME ERROR =(SUMPRODUCT((Price_LC_Phy1)*(PHEI_Distributor=$B$3)*(ARP_BUCKET=$A$4)*(Rolling_12=$A$3))/SUMPRODUCT((Price_LC_Phy1)*(PHEI_Distributor=$B$3)*(Rolling_12=$A$3)))
Solved by A. H. in 12 mins
I would like to use the formula SUMPRODUCT but would like to use it similar to SUMIFS. Currently I have the following... =SUMPRODUCT(PURCHASED[GROSS WEIGHT],PURCHASED[PAID PRICE])/SUM(PURCHASED[GROSS WEIGHT]) Now I would like to have it grab the SUMPRODUCT only if its for a certain item. In this case I want it to grab the SUMPRODUCT only if it is an item for EXPORT SALES which is listed in the EXPORT SALES/CLEANING column in the work sheet named PURCHASED.
Solved by O. D. in 17 mins
I need help in changing an existing sumproduct fomula
Solved by K. W. in 30 mins