+ Reply to Thread
Results 1 to 4 of 4

Averageifs help

  1. #1
    Registered User
    Join Date
    06-16-2018
    Location
    Manchester, England
    MS-Off Ver
    2016
    Posts
    138

    Averageifs help

    I have 50 numbers in 50 cells ranging 0 to 100.
    There are 5 0's and 7 100's, the rest of the numbers are the ones I want to find the average of.
    Without sorting high to low what would the formula be to exclude these numbers?
    Hope someone can help.
    Thanks

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Averageifs help

    Try

    =AVERAGEIFS(A1:A50,A1:A50,">0",A1:A50,"<100")

    Change A1:A50 to match your actual range of cells.

  3. #3
    Registered User
    Join Date
    06-16-2018
    Location
    Manchester, England
    MS-Off Ver
    2016
    Posts
    138

    Re: Averageifs help

    Great stuff.
    Thanks

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Averageifs help

    Try with
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Base on your data "A2" to "A51"


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ 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. [SOLVED] Averageifs
    By kent97 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2017, 02:40 AM
  2. Averageifs Help.
    By Thehomegroup in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-27-2017, 12:13 AM
  3. AVERAGEIFS can you use it with an or.
    By Vokey9 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 02-26-2016, 05:05 PM
  4. [SOLVED] Averageifs
    By yuenk in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-07-2015, 10:59 AM
  5. AverageIFS
    By rbirch in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-27-2015, 02:59 PM
  6. [SOLVED] IF NOT IN with AVERAGEIFS
    By trizzo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2014, 04:44 PM
  7. [SOLVED] averageifs help!
    By tgosman in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-30-2013, 09:34 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