Need to find average of an array if corresponding values are within a set range

Hi Guys,

Need your help. I need to calculate the average of an array if the corresponding values are falling in a particular range.

For example: say there is a list of unique value in A5:A100 in range of say 5 to 50, and corresponding to that in B5:B100 there are some values. now i need to find that if the value in A5:A100 are in the range of say >10 and <15 then return me the average of corresponding values in range B5:B100.

Is it possible? may be using if or match or something else.

I have also attached the excel for reference.

Thanks Pepe Le Mokko, i tried it.. but i think i am not able to use it properly. I am not able to create the criteria of Range say between 20-25 only then take average of corresponding values.

Hey tried the formula you suggested but it is giving me average of values only i.e., D column but i want criteria or condition on Values and output for corresponding values on E column.

Thanks sixthsense it is resolved using your formula... i just have to interchange the range and criteria in your formula.. as you have added condition on percentage and return average for values and i wanted other way round... thanks alot guys you all are great...