Originally Posted by

**jason.b75**
Ok, just to confirm one point that could break the formula if it's not done correctly.

Will any codes in Q be repeated? i.e. could one component be used in 2 or more different packages?

If it could, then how would it affect the layout of the tables?

Simple terms, this should work. (If you want the results as positive numbers then you just need to enclose the formula in ABS()

=SUMPRODUCT((P2=$V$2:$V$17)*$W$2:$W$17*R2)

But duplicates could cause errors.

You can't multiply with sumifs, only add.

## Bookmarks