Summing values based on two criteria

Hi all,

I have a problem that has been driving me mad, can someone help?

I have 3 named ranges (Property, Bin_Type & No.Of_Bins). What I need Excel to do is search the Property range for a specific type (ie School), then search Bin_Type for a specific type (ie Euro), then to total the value associated in the No.Of_Bins range.

An example below:

Property Bin_Type No.Of_Bins
School Euro 4
Council 1100 2
School Euro 1



What I need in another column is the total number of Euros at Schools (ie 5).

The example is very basic, the spreadie is approx 2000 rows, with various combinations of properties, bin types & bin numbers but if I can get this simple one done then I will know what to do.

What I cannot do is alter the spreadie in any way as it is used for other things.

I hope I have explained this clearly!

Thanks in advance.

Smartguy