+ Reply to Thread
Results 1 to 3 of 3

Aggregate Function - Value Error

  1. #1
    Registered User
    Join Date
    02-24-2015
    Location
    Houston, TX
    MS-Off Ver
    2013 and 2010
    Posts
    26

    Aggregate Function - Value Error

    I feel like this should be very simple...

    AGGREGATE(1,6,{0.509970149888418;0.5237677511337;#DIV/0!})

    Why am I getting a #VALUE! error???

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    08-07-2015
    Location
    AB, Canada
    MS-Off Ver
    Excel 2013 x64
    Posts
    132

    Re: Aggregate Function - Value Error

    The two ways I see you getting a #VALUE! error are:

    (1) You have selected a value {k} for the formula that is outside the length of your array

    or

    (2) You have manually entered your array like the example above. Referencing a range with those values should return you your desired result.

    Hope that helps!

  3. #3
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Aggregate Function - Value Error

    Hi,

    According to this page (http://www.exceluser.com/excel_help/...-aggregate.htm) the Average function (function 1) within Aggregate is one of the reference functions which doesn't take an array. As ThirdFret has said, I think you need to reference a range instead of numbers directly.

    I tried putting your three numbers into A1, A2 and A3 (using 1/0 to get Div/0!), then using =AGGREGATE(1,6,A1:A3) and that gave me the correct answer.

    Regards,
    Aardigspook

    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
    You don't need to give me rep if I helped, but thanks are appreciated.

+ 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] AGGREGATE function, If 0 show no value
    By antexity in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-07-2015, 11:59 AM
  2. Aggregate Function Using Sum
    By gtbaseball7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-01-2015, 02:19 PM
  3. [SOLVED] Using Aggregate results in #NAME? error
    By y_not in forum Excel General
    Replies: 6
    Last Post: 07-30-2014, 08:26 AM
  4. Aggregate Function
    By nav505 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2013, 03:20 AM
  5. Aggregate error
    By TomBP in forum Access Tables & Databases
    Replies: 3
    Last Post: 12-15-2010, 04:52 PM
  6. Aggregate function
    By stefantem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2006, 04:47 AM
  7. SQL - As part of an aggregate function ERROR
    By dave k in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-07-2005, 12:06 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