Doing a Count on a subset of records

[MCT]

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

[comment]

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.

[MCT]

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, 2015 by MCT

[comment]

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

[MCT]

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 ?  

[Lee Smith]

Try a google search for "fast summaries filemaker”.

[Fitch]

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

[MCT]

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