Average, max and min based on 3 criteria

Hi All,

Have a situation that I cannot seem to overcome.

On the attached sheet cells B1:D1 have drop down lists where selections can be made. Based on the type of contract selected and the value range selected and based on the criteria being applied to Columns I and J - I want to get the average % variations from col L along with the maximum and minimum variation %ge in the selected range.

Sounds pretty straight forward but nothing really seems to work for me! The averageifs formula I tried in column E can be seen in the attachment (E1) - for the max and min i tried the {=Max(if(and(criteria1, criteria 2, criteria 3), L2:L100))} option - but that did not work either. Please help.

Cheers,

Vbadud

Thanks a ton Ace - that worked well.
Hopefully I can build on that and insert more variations and selection options into those formulae. Thanks again.

vbadud