Average on basis of particular range

[musaddiq]

Hi,

anyone can help me in getting average on basis of range in between 2 values, sample file is attached. 

Thanks,

Musaddiq

[#2 · Accepted solution]

@musaddiq 

Hi Musaddiq

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.

=AVERAGEIFS(A2:A13,A2:A13,"<"&F4,A2:A13,">"&G4)

Anyhow an example is also attached for your understanding.

Hope it will help.

Thanks

Tauqeer