Table of Contents## Hack One of Excel’s Database Functions to Take the Place of Many Functions

Entire Site

**Excel’s database
functions— DSUM, DCOUNT,
etc.—can take the place of potentially thousands of functions,
thereby reducing both recalculation time and workbook
space**.

When using Excel’s database functions, you can specify up to 256 different criteria. You might, for example, want to sum amounts in column A where the corresponding amount in column B is greater than 100 and the corresponding age in column C is less than 40. If, however, you want to sum amounts where corresponding amounts in column B are less than 50, you need to use another function and a different range of criteria. It would much easier if you had a single function and could easily and quickly change the criteria! If you have never used Excel’s database functions before, we strongly recommend that you familiarize yourself with them, as they are very good for extracting statistical information from an Excel database or table.