Sum 05)

Count Data Based on Your Criteria – Counts Number of Times Combination Appears

This function allows you to select criteria columns then it Counts how many combinations of each there are.

To Use:

Using the  same row (usually the header row) click a single cell representing  your first criteria column, then holding the ctrl-key select other criteria cells in that same header row.

Now let up on the ctrl-key and navigate to this option which is found under the SUM menu item on The Data Wand toolbar.


You may not have a header row which identifies the data below. In this case you’ll still use a single row to select your criteria columns, it just wont have header labels. When you are prompted “Did you start with a header row” answer “No” to let the routine know it should treat that row as data.


Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc