North and South each order Basic and Plus kits. You need the number of clips and pads to pack for each destination. Multiply the component recipe by the kit counts.

Align the shared kit labels

Use Basic and Plus as columns in B2:C3. The Clips row is 2, 1 and the Pads row is 1, 3. In F2:G3, put North and South as columns. The Basic row is 6, 10 and the Plus row is 4, 5. Keep the kit order the same in both ranges.

The kit recipe columns and order rows both use Basic before Plus.

Illustrated inputs. Align the shared kit dimension before multiplying.

Check the upper-left total before using the grid

=MMULT(B2:C3,F2:G3)

Leave room for two rows and two columns. For North clips, check 2 × 6 + 1 × 4 = 16. The Clips row should be 16, 25 and the Pads row 18, 25. Keep the labels visible. Switching the kit order on only one side can still yield a number with the wrong meaning.

The result is 16 and 25 clips, then 18 and 25 pads, for North and South.

Illustrated output check. Calculate North clips by hand first.

Microsoft’s Excel function reference