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.
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.