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
Excel provides worksheet functions that make it easy to count things. What if you want to count records that match more than one criterion, though? Here are five easy ways you can count those records.

   Exact Matches with DSUM
The DSUM function is very handy when you need to calculate a sum based on data that matches criteria you specify. If you don't specify the criteria just right, however, you may not get the results you expect.

   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
Excel provides a number of tools you can use to help create forms. One of those tools is a checkbox. If you need to place lots of them in a worksheet, here's how.

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.