EXCEL AVERAGEIFS
The AVERAGEIFS is an Excel function used to return the average (arithmetic mean) of all numbers in a range of cells, based    on multiple criteria.
Syntax:
      =AVERAGEIFS(average_range,criteria1_range,criteria1,[criteria2_range,criteria2,……])
Arguments Or Parameters:
averange_range a range of cells or an array.
criteria1_range: specify the condition which cells to average.
criteria1: It is the range of cells you want to average.
Objective: Find the average Price of Dell Products with Thomas Michaels in cell I3.
   Step 1:
Type = sign in cell I3
Type AVERAGEIFS Function
  Step 2:
Select range E3:E22
Type “,”
   Step 3:
Select C3:C22
Type “,”
Type G3
Type “,”
   Step 4:
Select D3:D22
Type “,”
Type H3
Type “,”
Close Bracket with “)”
Press Enter
Conclusion: The AverageIfs formula has given the Average Price of Dell Products with Thomas Michaels in Cell I3 as 141.
