Nick,

Apologies.

Answer i'm after is 11,400

The crux of the problem is that the data in the [Volume] & [Value]
columns isn't necessarily in the same order.
Largest volume doesn't necesarily equate to largest value.

So i'm guessing i'll need to look first at the [Animal] column to
determine if it's a Cat, then at the [Colour] column to determine if
it's Black, then at the [Position] column to see if its' one of the
first three instances, and lastly to sum the data in the [Volume] and/
or [Value] column.

Hope this makes sense...



On 23 Nov, 15:54, "Niek Otten" wrote:
18,000 is the sum of all 5 instances of Black Cats.

What exactly do you require?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in ...

| Is it possible to sum a column of values based on the values of
| another column being the N largest / smallest?
|
| An example might help undestand the concept...
|
| Position Animal Colour Volume Value
| 1 Cat Brown 5,000 6,100
| 2 Dog Brown 4,900 6,200
| 3 Cat Brown 4,800 6,300
| 4 Dog Brown 4,700 6,400
| 5 Cat Brown 4,600 6,500
| 6 Dog Brown 4,500 6,600
| 7 Cat Brown 4,400 6,700
| 8 Dog Brown 4,300 6,800
| 9 Cat Brown 4,200 6,900
| 10 Dog Brown 4,100 7,000
| 11 Cat Black 4,000 7,100
| 12 Dog Black 3,900 7,200
| 13 Cat Black 3,800 7,300
| 14 Dog Black 3,700 7,400
| 15 Cat Black 3,600 7,500
| 16 Dog Black 3,500 7,600
| 17 Cat Black 3,400 7,700
| 18 Dog Black 3,300 7,800
| 19 Cat Black 3,200 7,900
| 20 Dog Black 3,100 8,000
|
| I'm looking to see the total Volume for the first three instances of
| Black Cats.
|
| (The answer i'm looking for is 18,000)
|
| Hope someone can help...