you need to relate items to sold items, then use the rollup column to sum that relation
remember… sum relation, not a lookup, I put lookup there just for better understanding what is in the sold sheet…
you can also use this technique to count sold items, get average or range …