Results 1 to 5 of 5

Thread: get average of column based on conditions

  1. #1

    get average of column based on conditions



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I would like to calculate average of a column, based on condition.
    let's take an example (see screenshot)
    Click image for larger version. 

Name:	example US.png 
Views:	14 
Size:	1.9 KB 
ID:	2944

    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. #2
    Hi,
    pl find attached the file. is it help you ?
    Attached Files Attached Files

  3. #3
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,317
    Articles
    0
    Excel Version
    2010 on Xubuntu

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    rafnews, please read the following article. It explains why you have been called out for crossposting:

    http://www.excelguru.ca/content.php?184


  5. #5
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,317
    Articles
    0
    Excel Version
    2010 on Xubuntu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •