+ Reply to Thread
Results 1 to 4 of 4

AverageIF formula Ignoring Certain values

  1. 08-07-2014, 03:18 PM #1
    jvandermolen
    jvandermolen is offline
    Registered User
    Join Date
    06-10-2014
    Posts
    6

    AverageIF formula Ignoring Certain values

    I was wondering how I could get a formula that averages only values from a range that are greater than -100. So lets say I have averages in cells #s in cells B2, B6, B9, and B10. However, I only want to average the numbers that are greater than -100. So if B9 contains -200 I don't want that to be considered in my average. Thanks for your help!
    Reply With QuoteRegister To Reply
  2. 08-07-2014, 03:32 PM #2
    Speshul
    Speshul is offline
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: AverageIF formula Ignoring Certain values

    Try

    =AVERAGEIF(B2:B10,">-100")
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.
    Reply With QuoteRegister To Reply
  3. 08-07-2014, 03:35 PM #3
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: AverageIF formula Ignoring Certain values

    What version of Excel does this have to work in?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  4. 08-08-2014, 11:52 AM #4
    jvandermolen
    jvandermolen is offline
    Registered User
    Join Date
    06-10-2014
    Posts
    6

    Re: AverageIF formula Ignoring Certain values

    That formula worked. Thanks for your help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUM(IF(FREQUENCY formula - ignoring two values
    By Karroog in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2014, 05:34 PM
  2. [SOLVED] Averageif ignoring #N/A
    By fgruhlke in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-07-2014, 10:26 PM
  3. [SOLVED] Formula to search range for either or both values, ignoring blanks
    By TC1980 in forum Excel General
    Replies: 6
    Last Post: 06-28-2013, 09:53 AM
  4. [SOLVED] AVERAGEIF - Ignoring 0 values - It's supposed to but not doing it.
    By BeachRock in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2013, 11:57 PM
  5. Formula for pulling values from one sheet to another ignoring the non zero values
    By pushd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2012, 09:48 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1