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.

=DSUM(B6:G21,F6,B1:C2)

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:

=DSUM(Table1[#All],Table1[[#Headers],[Sales]],B1:C2)

This workbook is available at this book's website. The filename is database formu-

las.xlsx.