AVERAGEIFS Function in Excel finds Average or Arithmetic Mean for the cells specified by a given set of conditions or criteria.
Download the sample data file to practice this function from the link given below.
https://1drv.ms/x/c/6e595f492fc64088/...