ExcelForumExample.xlsx

Is it possible to subtotal based on color? Attached is an example excel spreadsheet.
The "Example" tab is a sample data, and the "Finish" tab is how I would like it to be.
I appreciate the help, thanks.