+ Reply to Thread
Results 1 to 6 of 6

Average but ignoring DIV/0! errors

  1. #1
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    144

    Average but ignoring DIV/0! errors

    Good morning from ATL,

    Is there a way to get an average but ignoring #DIV! errors? Values are in non-consecutive cells so I can't use range formula like AVERAGEIF(D2:L2, "<>#DIV/0!"). Values are in D2,H2,L2.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Average but ignoring DIV/0! errors

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: Average but ignoring DIV/0! errors

    does this work
    =AGGREGATE(1,6,D2,H2,L2)
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,256

    Re: Average but ignoring DIV/0! errors

    Why is an average of an average usually incorrect?


    https://math.stackexchange.com/quest...ally-incorrect
    Attached Files Attached Files
    Last edited by popipipo; 01-29-2022 at 12:43 PM. Reason: edit file
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  5. #5
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    144

    Re: Average but ignoring DIV/0! errors

    They Worked!

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Average but ignoring DIV/0! errors

    Glad to help & thanks for the feedback.

+ 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. Weighted Average Ignoring Errors
    By SGarza0290 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-30-2018, 07:25 PM
  2. [SOLVED] Average even-numbered rows, ignoring #REF! errors
    By chrisrye13 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-20-2015, 09:45 PM
  3. Ignoring errors when calculating average
    By Excel15 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-20-2014, 03:16 PM
  4. [SOLVED] Ignoring errors
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-16-2013, 05:05 AM
  5. Ignoring errors
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-23-2011, 09:12 AM
  6. Replies: 1
    Last Post: 01-25-2011, 10:37 PM
  7. Ignoring errors
    By JSALDUTTI in forum Excel General
    Replies: 1
    Last Post: 12-02-2010, 04:45 PM

Tags for this Thread

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