Lurker the Second

04-11-2006, 14:24:18

I don't know a thing about Excel and am trying to make a spreadsheet. How do I get it do do the following:

Say I have 100 different items I want to manufacture. Each item contains some or all of up to 8 different components. The amount of each component required will vary from item to item. I want the spreadsheet to calculate the manufacturing cost of each item based on the component costs I input.

I have set the rows and columns up as follows:

Cells B2 through I2 are the cost to me of one unit of each of the components B through I.

Cells B3 through I3 are the amount of each component required to manufacture Item 3.

Cells B4 through I4 are the amount of each component required to manufacture Item 4.

And so on.

I tried to create a function that would set forth in each cell "J" the total cost of manufacturing each of the various items. Using the help function, it seemed to me the SUMPRODUCT function should work, but I think I'm confused about arrays. Anyway, I can't seem to make it work.

It seems to me this should be basic Excel, but damned if I can figure it out.

Say I have 100 different items I want to manufacture. Each item contains some or all of up to 8 different components. The amount of each component required will vary from item to item. I want the spreadsheet to calculate the manufacturing cost of each item based on the component costs I input.

I have set the rows and columns up as follows:

Cells B2 through I2 are the cost to me of one unit of each of the components B through I.

Cells B3 through I3 are the amount of each component required to manufacture Item 3.

Cells B4 through I4 are the amount of each component required to manufacture Item 4.

And so on.

I tried to create a function that would set forth in each cell "J" the total cost of manufacturing each of the various items. Using the help function, it seemed to me the SUMPRODUCT function should work, but I think I'm confused about arrays. Anyway, I can't seem to make it work.

It seems to me this should be basic Excel, but damned if I can figure it out.