Panda
11-30-2010, 10:29 AM
Hi There,
I have a spreadsheet (attached) containing 2 tabs, one with a list of units and components needed to make them. The other containing just a list of the components needed and with the expected delivery date in weeks along the columns.
I am trying to get the total parts in stock on the first tab, to look at the current week number and only show how many components I have in stock up to that point. So for example in Week 49 for component 1, 20 components are coming in but due to the way that I have set up my formula my spreadsheet is returning that I have 35 components in stock.
I think I need to your SUMPRODUCT but cant seem to get the formula working. Can anybody help?
Thanking you in advance
Phil
I have a spreadsheet (attached) containing 2 tabs, one with a list of units and components needed to make them. The other containing just a list of the components needed and with the expected delivery date in weeks along the columns.
I am trying to get the total parts in stock on the first tab, to look at the current week number and only show how many components I have in stock up to that point. So for example in Week 49 for component 1, 20 components are coming in but due to the way that I have set up my formula my spreadsheet is returning that I have 35 components in stock.
I think I need to your SUMPRODUCT but cant seem to get the formula working. Can anybody help?
Thanking you in advance
Phil