Microsoft Office Tutorials and References
In Depth Information
Figure 9-24: Using the DSUM function to sum a table using a criteria range.
You may find it cumbersome to set up a criteria range every time you need to use a
database function. Fortunately, Excel provides some alternative ways to perform condi-
tional sums and counts. See Chapter 7 for examples that use SUMIF, COUNTIF, and
various other techniques.