08-08-2019 08:04 PM
08-08-2019 09:27 PMSolution
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.
by David Schuur on October 13, 2018
by Justin Lee on May 22, 2018
by Kurt Turley on February 16, 2018