Database Functions

Tips, Tricks, and Answers

The following articles are available for the 'Database Functions' topic. Click the article's title (shown in bold) to see the associated article.

Counting Records Matching Multiple Criteria
Counting items in a data table that match a single criterion is easy; counting items that match two criteria is a bit more involved. This tip examines five different ways you can count items matching multiple criteria.

Indirect References to a DSUM Parameter
Indirect references can be very helpful in formulas, but getting your head around how they work can sometimes be confusing. Here's an example of using an indirect reference within another formula.

Inserting Large Numbers of Checkboxes
Easily add any number of checkboxes to an Exel worksheet.