Microsoft Office Tutorials and References
In Depth Information
The formula in cell B24, which follows, uses the DSUM function to calculate the sum of values in a table that
meet certain criteria. Specifically, the formula returns the sum of the Sales column for records in which the
Month is Feb and the Region is North.
In this case, B6:G21 is the entire table, F6 is the column heading for Sales, and B1:C2 is the criteria range.
This alternative version of the formula uses structured table references:
This workbook is available at this book's website. The filename is database formu-