We also have Free training videos on this site ( visit the Home page or the Training Page)

What is DSUM?

The DSUM in Excel, as a database function works over a range that can include one column or several columns. The basics of what the function entails are discussed below.

DSUM returns the total for the range of values which meet the criteria as set out by the user and can be indicated as follows:

= DSUM which includes database, field and criteria can also be range, field, and criteria.

The main difference between this function and the SUM is that it works in a database with set criteria.

The Database or Range

This includes the named range in the database for which criteria will apply. It entails the cells which make up the list. The labels for each of the lists in the database can be found at the top of the lists or columns – in their first rows.

The Field

It refers to the column number which spans from the left to the right. It specifies which columns are to be included in the criteria setting. The column labels are used in the criteria through double quotation marks such as “Income” but when numbers are used you do not use the double quotation marks.

The Criteria

This is a set of constraints that can be applied to obtain a specific answer. An example would be when you want the total for cycle sales between 1994 and 2001. You thus want to set criteria that will provide an answer greater than 1994, but smaller than 2001 to obtain the sum of sales for the period. It includes the range of cells which will be subject to the criteria or conditions applied.

DSUM is thus in layman’s terms the sum function applicable to an Excel database. At Miricle Solutions we provide extensive training on spreadsheet solutions. Contact us for more information on our training solutions for beginners to advanced users.