EXCEL DSUM
The DSUM is an Excel function to sum the values in a range that meets specified criteria.
 Syntax:
      =DSUM(database,field,criteria)
Arguments or Parameters
database: The range of cells that you want to apply criteria against.
field [optional]: column to sum the numeric values that meet the criteria.
criteria: The range of cells that meet the criteria.
Note:Â DSUM function sum the numeric values only.
Objective: Find the sum of the Price of the HP Product in cell I5.
   Step 1:
Type = sign in cell I5.
Type DSUM Function
  Step 2:
Select range A2:F21
Type “,”
   Step 3:
Type F2
Type “,”
   Step 4:
Select range H2:K3
Type “,”
Close the Bracket “)”
Press Enter
Result: The DSUM Function has summed the Price of HP Product in cell I5.
Â
