Get instant live expert help on how to use sumproduct

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

How do you use SUM, VLOOKUP, SUMPRODUCT formulas
Solved by K. L. in 23 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
how to sumproduct multiple rows in excel 2016?
Solved by Z. Y. in 28 mins
Hello I would like to use a sumproduct and then be able to drag down, but problem is that the data that needs to be sumproduct are on the right rows.
Solved by D. Y. in 26 mins
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