Using Lists function in Excel

Hi there,

I am trying to create a worksheet which can calculate the Outstanding Work Estimation based on available information.

The information available with me is presented in Rows 3, 4, 5, and 6. For these types of work orders, I have information regarding their Previous Outstanding Status, New Orders, Completed Orders, and at presented Unworked Orders (or Outstanding orders at the end of Jan 2008).

Second set of information is available in rows 9 to 23. This information provides for which type of orders were completed by Staff 1 and Staff 2.

Based on these two sets of information, I am trying to get to the point where I can calculate the following:

a) Applying the weight of orders (namely 1A, 1B, 1C and Blend) by using the drop down list function in column B, I should be able to get the results in Column C (C25 onwards till C40), Column D (D25 onwards till D40), and Column E (E25 onwards till E40). Simlarly for all other months...for February, March, and so on...till December 08.

Would appreciate if someone can tel me which formula to use to get it done in most simplest way.

Thanks,

Here's a formula to apply in C27, copied down:

Please Login or Register  to view this content.

which would be similar in F27 except the Indexed Ranges...

Not sure about columns D and E, though.. should they stay as is multiplying consecutive cells? Or should they somehow match up someway to rows 9:23?