average column based on sum of 2 columns

		Microsoft Office Forums > Microsoft Excel > Excel
average column based on sum of 2 columns

FAQ

Thread Tools

Display Modes

12-11-2014, 04:41 PM

rafnews

Windows 7 64bit average column based on sum of 2 columns

Office 2010 64bit

Novice

Join Date: Oct 2012

Posts: 5

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,

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:40 PM.