+ Reply to Thread
Results 1 to 3 of 3

Exclude a Certain Value from the "Average" Function?

  1. #1
    Registered User
    Join Date
    11-17-2018
    Location
    East Coast, USA
    MS-Off Ver
    Office 365
    Posts
    2

    Exclude a Certain Value from the "Average" Function?

    Hello, everyone, I am requesting help with a formula. I have a very basic, easy, rudimentary spreadsheet that keeps track of my electric bills.

    Attached to this message is a copy of the spreadsheet. As you can see, it has a cell for the average of all the bills.

    What I'd like to do is create a cell that displays the average for all the bills that are under 90 dollars (which are all part of Column B). I'd like to exclude from this calculation any and all bills that are $90.00 and over. I'm not sure how to do that.

    Do I use the Averageif or Averageifs options? Or do I just need to modify the Average option?

    Thank you. M. Pendleton
    Attached Files Attached Files
    Last edited by MLPendleton; 02-01-2020 at 10:40 PM.

  2. #2
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Exclude a Certain Value from the "Average" Function?

    Your attachment doesn't appear. Yes, use AVERAGEIF, along the lines of =AVERAGEIF(range,"<90").

  3. #3
    Registered User
    Join Date
    11-17-2018
    Location
    East Coast, USA
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Exclude a Certain Value from the "Average" Function?

    I realized I uploaded the wrong file. I've uploaded the correct file now. Thank you for replying.

+ 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. Replies: 1
    Last Post: 02-05-2019, 02:01 PM
  2. EXCEL 2003 - Need an "AVERAGEIF" formula to exclude "0" in average
    By kerry0507 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2015, 03:37 PM
  3. [SOLVED] How can I copy "=Average(A1:A2)" and paste as "=Average(A3:A4)" in next space in column?
    By matt_m_is_me in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-27-2014, 11:02 AM
  4. Help Needed to get Filters Using "Include" and "Exclude" multiple values on one column.
    By alfykunable in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2012, 04:03 AM
  5. Exclude "#VALUE!" from counting the average
    By ilya49 in forum Excel General
    Replies: 2
    Last Post: 12-29-2009, 08:12 PM
  6. exclude values of "0" when calculating an average
    By drocco in forum Excel General
    Replies: 4
    Last Post: 08-01-2008, 02:03 PM
  7. Replies: 2
    Last Post: 07-11-2007, 06:35 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