Nick,

Don't think Bob's solultion will work for this example.

The first three instances where [Animal] is Cat & [Colour] is Black
are as follows:

Col A Col B Col C Col D Col E
Position Animal Colour Volume Value
11 Cat Black 4,000 7,100
13 Cat Black 3,800 7,300
15 Cat Black 3,600 7,500

Using Bob's example i can get to the first three [Volume] instances
(1,1,400) using the following:

{=SUM(LARGE(IF((B2:B100="Cat")*(C2:C100="Black"),D 2:D100),{1,2,3}))}

However their respective [Value] numbers aren't necessarily in the
same descending order, so the same formula to return the [Value] total
(21,900) doesn't work.


Any ideas?

Cheers


On 23 Nov, 16:39, "Niek Otten" wrote:
Then use Bob Phillips' solution

--
Kind regards,

Niek Otten
Microsoft MVP - Excel