+ Reply to Thread
Results 1 to 3 of 3

sum the POPULATION of the 3 highest AREAS

  1. #1
    Registered User
    Join Date
    04-10-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    7

    sum the POPULATION of the 3 highest AREAS

    Hello!

    It looks a very simple problem but i can't figure it out...
    So i ask for your help.

    Is there a way of "sum the POPULATION of the 3 highest AREAS" ?
    Population in column A
    Areas in column B

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,443

    Re: sum the POPULATION of the 3 highest AREAS

    If the areas were all distinct values, that is, no duplicates, you should be able to use

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


    If there were duplicate areas and you wanted only the first largest 3, then you'd need the more exotic

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


    The ROW(A2:A8)/2^10 term subtracts small monotonically increasing fractional values from the presumed integer values in column A, which ensures all resulting values are distinct, and duplicate values in rows with lower row numbers would be used first. Adjust the denominator, 2^10, as needed.

  3. #3
    Registered User
    Join Date
    04-10-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: sum the POPULATION of the 3 highest AREAS

    Thank you! The solution provided Worked like a charm!

+ 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. Observation of areas whose population mixes - panel data set
    By BenRonen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2019, 08:54 PM
  2. Replies: 3
    Last Post: 05-27-2019, 06:19 AM
  3. Replies: 3
    Last Post: 06-09-2016, 12:51 PM
  4. [SOLVED] Max formula to return total of highest, second highest and third highest value
    By JonWilf in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-06-2016, 08:20 AM
  5. [SOLVED] Count rows between two areas in a collection/selection of multiple areas
    By JTwrk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2012, 10:38 AM
  6. Replies: 0
    Last Post: 07-10-2012, 08:37 AM
  7. VBA code to find highest and 2nd highest number based in criteria
    By Michael007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-25-2011, 08:38 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