Then use Bob Phillips' solution

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ...
| 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...
|