I have a large spreadsheet where certain rows are colored red. I would like
to sort on one column, then total the number of red rows in that group as
well as obtain a grand total of the number of red lines. How do I accomplish
this?

Thank you in advance for your help to an Excel novice.