+ Reply to Thread
Results 1 to 4 of 4

Aggregate Function Using Sum

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

    Aggregate Function Using Sum

    I am trying to add one row if the another row is not 0. I am using the Aggregate function. Here is what I have and I'm getting a #VALUE! error.

    =AGGREGATE(9,6,$K622:$DG622/($K258:$DG258<>0))

    Also, what is the default [k] value for this function? I've tried default and using 1. Not quite clear on what [k] means...

    Thanks!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    31,818

    Re: Aggregate Function Using Sum

    Try this (array entered : CTRL-SHIFT-ENTER)
    =IF($K258:$DG258<>0,AGGREGATE(9,6,$K622:$DG622))

    or (non-array)
    =SUMIF($K258:$DG258,"<>0",$K622:$DG622)
    Glenn



  3. #3
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Aggregate Function Using Sum

    Quote Originally Posted by gtbaseball7 View Post
    Also, what is the default [k] value for this function? I've tried default and using 1. Not quite clear on what [k] means...
    There isn't a k value when you use 9 (sum). That only applies when it fits the function in question, I.e with functions 14 to 19, SMALL, LARGE, PERCENTILE and QUARTILE
    Audere est facere

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

    Re: Aggregate Function Using Sum

    Daddy LL-

    Thank for your response. Why would the AGGREGATE function as I have it set up, return a value error?

    You are normally well informed when it comes to the AGGREGATE function. I prefer not to use Array formulas as I am not the only one accessing this file. I hope you can help me understand. Thanks.

+ 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. Aggregate function to number rows
    By cdumper in forum Excel General
    Replies: 9
    Last Post: 09-27-2014, 07:22 PM
  2. Aggregate Function
    By nav505 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2013, 03:20 AM
  3. Problem with Aggregate Function ADO SQL
    By Kyle123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2010, 07:44 AM
  4. Aggregate function
    By stefantem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2006, 04:47 AM
  5. basic aggregate function question
    By kamea999 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-19-2005, 03:00 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