Aug 08 2019 08:04 PM
Hi,
anyone can help me in getting average on basis of range in between 2 values, sample file is attached.
Thanks,
Musaddiq
Aug 08 2019 09:27 PM
Solution
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
Aug 08 2019 09:27 PM
Solution
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