I am trying to accomplish in Excel following case but I am not able to make it work. Could you please help?
The task is to calculate quantity of each part. Example: PART 1 = (2 x 50) + (1 x 250) + (1 x 400) + (1 x 300) = 1050.
The problem is, that I can not touch/sort the upper table with bikes to be able to use simple SUMPRODUCT?
Picture:
Link to excel sheet: https://www.dropbox.com/s/72eqn9akzzw83z0/Parts per bike version.xlsx?dl=0
Could you please give me an advise at least which direction should I look?
Thanx
- I have got given volume data for asseblies (as example Ive choosed bikes)
- In second part of table I have number of parts needed for each assembly
The task is to calculate quantity of each part. Example: PART 1 = (2 x 50) + (1 x 250) + (1 x 400) + (1 x 300) = 1050.
The problem is, that I can not touch/sort the upper table with bikes to be able to use simple SUMPRODUCT?
Picture:

Link to excel sheet: https://www.dropbox.com/s/72eqn9akzzw83z0/Parts per bike version.xlsx?dl=0
Could you please give me an advise at least which direction should I look?
Thanx