Microsoft Office Forums - View Single Post - [Solved] average column based on sum of 2 columns

Thread: [Solved] average column based on sum of 2 columns

View Single Post

Old

12-11-2014, 04:41 PM

rafnews

rafnews is offline

rafnews uses Windows 7 64bit

Windows 7 64bit rafnews uses Office 2010 64bit

rafnews uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Oct 2012

Posts: 5

rafnews is on a distinguished road

Question

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,

Reply With Quote