+ Reply to Thread
Results 1 to 3 of 3

Help with AverageIf function

  1. #1
    Registered User
    Join Date
    01-15-2014
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    12

    Help with AverageIf function

    I am trying to get an average of 4 cells in 4 different columns (A2,C2,E2 AND G2) and if one of the cells has a zero then ignore it.
    For example:
    A2=5
    C2=10
    E2=9
    G2=0
    the average would be 8
    the way I've entered the formula is:
    =AVERAGEIF(A2,C2,E2,G2,>0)
    I keep getting the error "Too many arguements"
    Where am i going wrong?
    Thanks for the help
    Bob

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Help with AverageIf function

    If B2, D2 and F2 contain text values, try this.....

    Please Login or Register  to view this content.
    And if B2, D2 and F2 may also contain numbers, try this simple approach.....

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    Re: Help with AverageIf function

    Or

    =SUM(A2,C2,E2,G2)/INDEX(FREQUENCY((A2,C2,E2,G2),0),2)
    Marcelo Branco

+ 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] Averageif Function in VBA
    By benzacac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2013, 11:59 AM
  2. Need help with averageif Function
    By irfanparbatani in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-25-2012, 09:52 PM
  3. AVERAGEIF function
    By thespaceman in forum Excel General
    Replies: 5
    Last Post: 08-24-2011, 01:59 PM
  4. AverageIf function
    By kgbxjester in forum Excel General
    Replies: 3
    Last Post: 09-15-2009, 02:03 PM
  5. AverageIF function?
    By johnmitch38 in forum Excel General
    Replies: 8
    Last Post: 06-25-2009, 05:53 AM

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