I have a parts list of screws in a bunch of different assemblies. Assemblies are across the top/columns and the part numbers are listed vertically in rows to create a matrix of the number of parts for all assemblies. I also have a list of how many assemblies are to be produced in the next 20 years. I want to calculate how many of each screw will be required in the next 4-, 8- and 12 years. I just calculated it manually by summing the sum of 4 years' production times the number of screws for each assembly, but this turns out to be a nasty long formula. I know there has to be an easier way, but anything I've played with doesn't work correctly.
Array Multiplication
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!