|
|
#1
09-03-2013, 07:28 AM
|
|||
|
|||
Sum Average usage Based on two sheets
I have a work book that looks at usage. 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 average of the total quantites. I have attached a small sample of my sheet and what I am trying to accomplish. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Column Chart Average | blaqsheep | Excel | 0 | 02-07-2012 07:04 PM |
| Average minus outliers? | markg2 | Excel | 2 | 01-07-2012 05:46 PM |
| Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
| 'AVERAGE' Formula | nfphilpot | Excel | 3 | 11-24-2010 02:19 PM |
 Average of many rows
|
speedycorn1 | Excel | 1 | 10-30-2010 07:54 PM |
Windows 7 64bit 
Office 2007
Threaded Mode