Get instant live expert help on sumproduct vs sumifs
“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
i heard that sumproduct can reference a closed workbook? if so how can i change my sumifs to sumproduct?
Solved by A. J. in 22 mins
I need help with sumifs or sumproduct to calculate a total time due to a certain factor.
Solved by C. C. in 16 mins
why is this not working : +SUMPRODUCT(--(A2:A9=M1), --(B2:B9>=EDATE(TODAY(),-M2)),D2:D9,C2:C9)/SUMIFS(D2:D9,A2:A9,M1,B2:B9,>EDATE(TODAY(),-M2))
Solved by Z. A. in 24 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
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