|
|
#2
12-12-2014, 12:50 AM
|
||||
|
||||
Perhaps add a helper column to make the sum ( you can hide it) then use the AVERAGEIF function with the Pricve and sum column to calculate the result.
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Need help on duplicates in column; deciding which to keep based on other column
|
nwcf | Excel | 3 | 01-31-2014 09:43 AM |
|
Sum Average usage Based on two sheets
|
bremen22 | Excel | 3 | 09-03-2013 11:27 AM |
| Columns. How to move the left column so it's to the right of the 'right' column ? | Vit | Word | 9 | 11-21-2012 12:57 PM |
| Column Chart Average | blaqsheep | Excel | 0 | 02-07-2012 07:04 PM |
| how to create two columns based on a certain criterior from the original two column? | where_pc | Excel | 3 | 06-13-2011 10:39 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode