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