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.
Search JabSto ::




Custom Search