EXCEL SUMIF
The Sumif is an Excel function to sum the values in a range based on specific criteria.
Syntax:
=Sumif(range,criteria,[sum_range])
Arguments or Parameters:
range: a range of cells or an array.
criteria: specify the condition in which cells should be sum.
Sum_range [optional]: It is the range of cells to sum together.
Objective: Find the count of Dell Products in cell H4.
   Step 1:
Type = sign in cell I3
Type Sumif Function
  Step 2:
Select range D2:D23
Type “,”
   Step 3:
Type G4 in criteria
Type “,”
Select range E3:E23 in [sum_range]
Close Bracket with “)”
Press Enter
Conclusion: The SUMIF formula in cell H4 calculated the sum of Dell’s values as 656.
