Sum of each column from individuals costs times amount of items

[Iceline]

Hello,

I'm working on a game and I want to make an overview of required materials for ingame items. Column B contains items and column C the required amount of those items. Columns D through P (and proably beyond) contain the required materials for that item.

I'm looking for a way to get the total required amount of materials by making a sum of all required materials for each item times the desired amount of that item.

Example
Item1: Costs 2 Wood and 5 Stone
Item2: Costs 1 Wood and 3 Stone

If I want 3 Item1's, I'd need: (3x2=) 6 Wood and (3x5=) 15 Stone.
If I want 2 Item2's, I'd need: (2x1=) 2 Wood and (2x3=) 6 Stone.

The total required amount for the Wood column would be 8 (6+2)
The total required amount for the Stone column would be 21 (15+6)

Is there a formula for this or will I have to solve this by making hidden subtotal columns or using VBA?

 

[Truiz]

could you post an example on how your data looks like perhaps upload a sample datasheet