DSUM

The Excel DSUM function calculates a sum of values in a set of records that match criteria. The values to sum are extracted from a given field in the database, specified as an argument. The database argument is a range of cells that includes field headers. The field is the name or index of the field to query, and the criteria is a range of cells with headers that match those in database. Note that field can be specified with a name or index. Using the example above, you can get the sum of all "Blue" sales with either of the formulas below: The criteria can include a variety of expressions, including some wildcards. The table below shows some examples: Note: support for wildcards is not as extensive as with other functions like COUNTIFS, SUMIFS, MATCH, etc. For example, the pattern "???" wi