Excel.Tips.Net ExcelTips (Menu Interface)

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.


Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.