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