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,

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

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)

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

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