|
|
#1
12-11-2014, 04:41 PM
|
|||
|
|||
average column based on sum of 2 columns
Hi,
I would like to calculate average of a column, based on condition. let's take an example (see screenshot) example US.png if SUM(adults + Children) >=5, i want to calculate average price of Hotel room. so in my example to calculate average of (2000 and 5321). How can i do that ? thx, 
|
| Thread Tools | |
| Display Modes | |
|
|
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