+ Reply to Thread
Results 1 to 2 of 2

Exclude Values from Average formula

  1. #1
    Registered User
    Join Date
    04-20-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    25

    Exclude Values from Average formula

    Hi Excel Experts

    Please see the attached file and help me on the formula to exclude top 5 least values from set of data and count average.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,820

    Re: Exclude Values from Average formula

    Is there a reason (backwards compatibility maybe?) that you need AVERAGE(IF(...))? It seems to me that the AVERAGEIFS() function (https://support.office.com/en-us/art...8-f7c5c3001690 ) is easier to use for this. Something like =AVERAGEIFS(average range,average range,">"&SMALL(average range,5))
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Average of last 5 values but to exclude any blank cells.
    By tb2000 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-12-2019, 03:14 PM
  2. Replies: 1
    Last Post: 07-19-2012, 05:09 PM
  3. How to average cells but exclude 0 values?
    By Billznik in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2008, 06:26 AM
  4. Average needed, but want to exclude some values
    By hibiscus27 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2007, 10:49 AM
  5. Replies: 1
    Last Post: 07-06-2006, 07:30 AM
  6. Limit or Exclude cells in Average and Sum formula
    By dagger in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 09-06-2005, 12:05 PM
  7. Replies: 1
    Last Post: 07-20-2005, 06:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1