By using the DSUM function, you can specify criteria and conditions regarding which cells should be added together. The DSUM Function differs from the SUM function in that it lets you specify one or more criteria which act as data filters. In the example below we calculate the total Filo Mix sales for the Month of January that are greater than $50.
Syntax
DSUM(database,field,criteria)
Database: is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
Field: indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as “Age” or “Yield,” or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
Criteria: is the range of cells that contains the conditions that you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.
Applies To: MS Excel 2003, 2007 and 2010:
- Select cell E5
- Enter in the below formula
a. =DSUM(A1:C26,3,E1:G2)
b. The answer will be $1,797.80 (That is the total Filo Mix Sales for values greater than $50 for the Month of January)
If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email enablement@alchemex.com and yours could be the next Tip of the Week.
Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations
