Tips, Tricks, and Answers

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Indirect References to a DSUM Parameter DSUM, like most other Excel worksheet functions, requires parameters that define how the function does its work. If you don’t provide those parameters in the manner Excel expects, then you can get errors or incorrect results. This tip explains how you can overcome one such error to indirectly reference the data you want summed. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Inserting Large Numbers of Checkboxes Easily add any number of checkboxes to an Exel worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)