EXCEL AVERAGEIF
The AVERAGEIF is an Excel function used to calculate an average of all cells in a given range that meet a certain             condition.
Syntax:
      =AVERAGEIF(range,criteria,[average_range])
Arguments or Parameters:
range: a range of cells or an array.
criteria: specify the condition which cells to average.
Average_range [optional]: it is the range of cells you want to average.
Objective: Find the average Price of Dell Products cell H2.
   Step 1:
Type = sign in cell H2.
Type AverageIf Function
  Step 2:
Select range D3:D22
Type “,”
   Step 3:
Type “Dell” in criteria
Type “,”
Select range E3:E23 in [sum_range]
Close Bracket with “)”
Press Enter
Conclusion: AverageIf formula has given the Average Price Of Dell Products in Cell H2.
