sum the POPULATION of the 3 highest AREAS

1. sum the POPULATION of the 3 highest AREAS

Hello!

It looks a very simple problem but i can't figure it out...

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

Thank you!

2. 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:
`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:
`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. Re: sum the POPULATION of the 3 highest AREAS

Thank you! The solution provided Worked like a charm!

There are currently 1 users browsing this thread. (0 members and 1 guests)