#1
|
|||
|
|||
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, |
#2
|
||||
|
||||
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.
__________________
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 |
#3
|
|||
|
|||
i thought about it, but i would like to be smart and to do it without an intermediate column like =SUM (B:B, C:C)
|
#4
|
||||
|
||||
Cross post without links http://www.excelforum.com/excel-form...onditions.html
http://www.mrexcel.com/forum/excel-q...m-2-cells.html http://www.excelguru.ca/forums/showt...on-conditions&
__________________
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 |
#5
|
||||
|
||||
As I do not have time to waste checking all cross posts, my help ends here. Good luck
__________________
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 |