anyone can help me in getting average on basis of range in between 2 values, sample file is attached.
View best response
When you have multiple criteria you can use AVERAGEIFS(). Below is your desired formula but it will give #DIV/0! because none of the values fall between the range defined in your sheet.
Anyhow an example is also attached for your understanding.
Hope it will help.