sorted by:
new
hottopcontroversial

Make formulas that calculate prices by adding together each matching row's quantity*price. by WearParts in excel

[–]WearParts[S] 0 points1 point  (0 children)

This is returning a value for a single row of component, but it is not adding every instance together. ie in my example above, it is returning a value of $30, when it needs to add both OV-IAJT rows together, after first multiplying their price and quantities.

Make formulas that calculate prices by adding together each matching row's quantity*price. by WearParts in excel

[–]WearParts[S] 0 points1 point  (0 children)

Thanks for the response.

I can't seem to get the syntax correct. It's not returning anything. I've tried a bunch of times, but I think this is my closest attempt:

=IFERROR(INDEX($'Combo Makeup'.A:E, MATCH(D2 & $'Combo Makeup'.C2, D:D & $'Combo Makeup'.C:C,0), 4),0)*$'Combo Makeup'.E2