+ Reply to Thread
Results 1 to 3 of 3

Thread: ignoring #N/A numbers when doing AVERAGE()

  1. 03-11-2010, 06:43 AM #1
    FortuneSyn
    FortuneSyn is offline
    Registered User
    Join Date
    01-25-2010
    Location
    Joinville, Brazil
    MS-Off Ver
    Excel 2007
    Posts
    32

    ignoring #N/A numbers when doing AVERAGE()

    Hi!

    I have a chart with percentages that I want to average. However, I use #N/A formula on the cells that don't have values (so the graph doesn't get messed up). How can I make the AVERAGE() formula ignore the #N/A values so I can get the proper average?

    Thanks in advance!
    Reply With Quote Reply With Quote
  2. 03-11-2010, 06:46 AM #2
    DonkeyOte
    DonkeyOte is offline
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,423

    Re: ignoring #N/A numbers when doing AVERAGE()

    If as implied you're using XL2007 you can use AVERAGEIF

    =AVERAGEIF(yourrange,"<>#N/A")

    (change delimiter to ; if required)
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With Quote Reply With Quote
  3. 03-11-2010, 02:47 PM #3
    FortuneSyn
    FortuneSyn is offline
    Registered User
    Join Date
    01-25-2010
    Location
    Joinville, Brazil
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: ignoring #N/A numbers when doing AVERAGE()

    Works perfectly, thanks!
    Reply With Quote Reply With Quote
+ 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)

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.2.0