I'm trying to figure out how to do a "Count" on a subset of records. I can do a search to find the records I need and do a count of the number of records found, but I also need a "count" on a subset of records.

For example:
I can do a FIND to list all of the widgets (1record per widget) I've sold in the month of November and do a COUNT of the number of  records to total the number sold. I also need to count the number of Red, Blue, and Green widgets within that same list.

i.e.  November: 30 widgets sold;  12 Blue,  10 Red,  8 Green

The simple way to do this is to place the summary field that counts the records in a sub-summary (when sorted by Color) part.

Ahh.. I see how that would work, thank you. Unfortunately I need to maintain the sort order, in my case, alphabetical order of the name not the color.

Edited December 1, 201510 yr by MCT

In such case it won't be simple. Are you familiar with the method known as Fast Summaries?

I am not. I did a Google search, and it looks like that may be the ticket. Can you recommend a good source/site for step-by-step details ?  

Try a google search for "fast summaries filemaker”.

http://filemakerhacks.com/2011/06/23/fast-summaries/

Will do. Thank you everyone for your help. I truly appreciate it. I better get busy.