I have a spreadsheet to show inventory usage since a location has opened. There are two sheets. Sheet 1 contains usage data for 1 month. Sheet 2 contains usage data with no restrictions. The data is generated by a data connection to an Oracle database.




Here is what I am trying to accomplish.....
On sheets 1 and 2 there is a Nomenclature Key. For each key that is on sheet 1 there will be a coresponding key on sheet 2. For each time the key appears on sheet 2 I want to get the sum of quantity used (col B). I then need to divide that by the number of months that has based from June 2012 until the month of the current system date.

Attached Files

Book1.xlsx (48.5 KB, 9 views)